Those who have really vast Excel spreadsheets can reduce them in distance by stealing a few rows or columns. Excel 2010/13 includes Hide/Unhide options with that we can temporarily mislay columns and rows from view. As such, we don’t have to delete any rows or columns and afterwards name the Undo choice to put them behind in a spreadsheet.
To censor a few rows from a spreadsheet, press the Ctrl key and name a rows to remove. Then right-click their quarrel numbers on a distant left of a spreadsheet, and name the Hide option. The comparison rows should afterwards disappear from a Excel spreadsheet.
To put them back, name the rows directly above and next a ones we private from a spreadsheet. Then we should right-click a comparison quarrel numbers, and click the Unhide option. The rows should afterwards reappear in a Excel spreadsheet.
You can censor columns from a Excel spreadsheets many a same. Select a few of a mainstay headings to remove from a spreadsheets while dire Ctrl. Note that they don’t indispensably have to be adjacent columns. Right-click one of a comparison mainstay headings, and afterwards click Hide to mislay them as in a shot below.
Then name a columns to a left and right of a ones that are dark from view. Then we should right-click on a comparison mainstay headings, and select Unhide from a context menu. The dark columns will afterwards reappear in a Excel spreadsheet.
Hiding columns and rows competence be handy for timorous incomparable Excel 2010/13 spreadsheets down to size. In addition, with a Hide/Unhide options we can also imitation a many applicable columns and rows from spreadsheets but carrying to delete anything from them.
Article source: http://dottech.org/154930/how-to-hide-and-unhide-rows-and-columns-in-excel-2010-an-2013-tip/
Speak Your Mind