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 [...]
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 [...]
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 [...]
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 [...]
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 [...]
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 [...]
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 [...]
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 [...]
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 [...]
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 [...]
