Excel Digest

  Excel help for the rest of us

Archive for the 'Formatting' Category

14 Oct

How to change Excel default font

To change Excel default font name or size, follow these steps:
1. In the Tools menu click Options.
2. When you get the Options window, click the General tab.
3. Towards the bottom of the window there is a label called “Standard font“, and to the write of it are two combo boxes (drop down) for the font [...]

20 Aug

How to change worksheet tab color

Do you really need to change the tab color of a worksheet?
Well, you may have a workbook with a considerable number of worksheets, and you may just want one or two of the worksheets to stand out from the crowd. Anyhow for any reason you may have here is how to do it:
1. Switch to [...]

17 Aug

How to set a background for a worksheet

To add a background to a worksheet follow these steps:
1. Switch to the worksheet where you want to add a background.
2. Click Format, point to sheet then click Background.

3. The Sheet Background window will open. Select your picture then click Insert.
4. The selected picture will be repeated as a background.
To remove the background:
1. Switch to [...]

03 Aug

How to find cells that have conditional formats

If you want to find cells that have conditional formatting, then you have two choices:
1. Find cells with any conditional formatting.
2. Find cells that have conditional formatting settings identical to the settings of a specific cell.
For option 1 do the following:
1. On the Edit menu, click Go To. The Go To window will open

2. Click [...]

31 Jul

How to format a date with month in upper case

If you want to format a date with month in upper case, then hear is how you do it:
1. The general format for getting the month in three character is this:
=TEXT(cell_reference,”mmm”)
2. To get upper case you enclose the TEXT function within the UPPER function as follows:
=UPPER(TEXT(cell_reference,”mmm”))
So if we have a date in cell A1 for [...]

14 Jun

How to convert columns to rows, or rows to columns

If you have a column of text like this:

Monday

Tuesday

Wednesday

Thursday

Friday

Saturday

Sunday

And you want to put this data in a row like this:

Monday
Tuesday
Wednesday
Thursday
Friday
Saturday
Sunday

Instead of moving the data manually, you can use an option of the Paste Special command as follows:

Select the data in the column.
Right click and then select copy.
Select the first cell in the destination row.
Right click [...]

18 May

How to format a cell based on the value of another cell (conditional formatting)

Select the cells for which you want to add conditional formatting.
On the Format menu, click Conditional Formatting.
The Conditional Formatting dialogue will open.

In the first combo box select Formula is.
In the text box next to it [...]

11 May

Function to return the day of the week in text (Name of the day)

Excel has a built in function which returns the day of the week corresponding to a date. The day is given as an integer, ranging from 1 (Sunday) to 7 (Saturday), by default, or 1 (Monday) to 7 (Sunday) if you use a return type of 2. But there is no direct function to return [...]

18 Apr

How to apply a cell format to other cells

1. Select the cell which you have already formatted.
2. Click Format Painter in the standard toolbar.
3. Click the cell on which you want to apply the format. The format of the first cell will be applied to the new [...]

16 Apr

How to Repeat Heading Row(s) on Every Page

If you have one or more heading rows in your worksheet and you want to print that worksheet then the heading row(s) will be printed on the first page only (default).
To print the heading row(s) on every page do the following:

Click File then click Page Setup .The Page Setup [...]

© 2008 Excel Digest | Entries (RSS) and Comments (RSS)

GPS Reviews and news from GPS Gazettewordpress logo