Excel’s Go To feature provides a quick way to select certain types of cells. For example, if you wanted to apply the same fill colour to all formula cells on a sheet, you can do that in five easy steps using Go To.
Tag Archives: formatting
Excel – Find and Replace for formats
Excel’s Find and Replace is quick and powerful. It’s great for replacing text. Did you know you can also use it to replace formatting? Well you can in Excel 2007 and Excel 2010.
Beware Excel’s Merge and Center format
Purge the Merge
Ever had an error message which stated that you “Cannot change part of a merged cell”?
Well the merge format is the culprit. The Merge and Center icon on the Home ribbon is commonly used to format headings to make them look good by centering a heading across the cells below it.
Copy formats quickly with the Format Painter
Do you know the mouse trick?
One of Excel’s most useful Ribbon / toolbar icons is the Format Painter.
To use it first select a cell or range that has the format you want to use. Then you click the Format Painter icon and click another cell to apply all the formats that the original cell had.
Insert a line break in a cell
Alt + Enter
The shortcut is
Alt + Enter
To insert a line break within a cell hold down the Alt key (next to your space bar) and press Enter. This inserts a fixed line break within the cell.