2015/05/26
Excel-erate Your Spreadsheet Skills
Unhide a Particular Column
If you have several columns hidden (e.g. columns H: K) and you want to unhide just one (e.g.column H), here's how to avoid having to unhide all the columns first and re-hide the others.
In the Name Box (the small white box to the left of the formula bar) type a cell address that is in the column you want to unhide - e.g. H1. Cell H1 will be selected even though the column is hidden. Then, from the Format menu select Column, Unhide. Only column H is unhidden.
The same trick will work for unhiding a hidden row.
Claire Morris
IT Training Team Lead
McDermott Will & Emery
And
Excel's Paste Special command -
Microsoft Excel 2010 normally copies all the information in the range of cells you select when you paste the data. Use Excel's Paste Special command to specify other options, such as pasting only the cell contents (without the formatting) or only the formatting (without the cell contents).
To paste particular parts of a cell selection, click the Paste button arrow on the Ribbon's Home tab. Then, click Paste Special on its drop-down menu to open the Paste Special dialog box.
Paste only some of a copied or cut cell's properties with Paste Special.
You can specify which parts of the current cell selection to use by selecting the appropriate Paste Special options:
- All to paste all the stuff in the cell selection (formulas, formatting, you name it). This is what happens when you paste normally.
- Formulas to paste all the text, numbers, and formulas in the current cell selection without their formatting.
- Values to convert formulas in the current cell selection to their calculated values.
- Formats to paste only the formatting from the current cell selection, without the cell entries.
- Comments to paste only the notes that you attach to their cells (kinda like electronic self-stick notes).
- Validation to paste only the data validation rules into the cell range that you set up with the Data Validation command.
- All Using Source Theme to paste all the information plus the cell styles applied to the cells.
- All Except Borders to paste all the stuff in the cell selection without copying any borders you use there.
- Column Widths to apply the column widths of the cells copied to the Clipboard to the columns where the cells are pasted.
- Formulas and Number Formats to include the number formats assigned to the pasted values and formulas.
- Values and Number Formats to convert formulas to their calculated values and include the number formats you assigned to all the copied or cut values.
- All Merging Conditional Formats to paste conditional formatting into the cell range.
Submitted by Maritta Terrell
Trainer, Lloyd Gosselink