Protect or lock hidden columns with Excel feature. Click the Select All button (the button at the intersection of row numbers and column letters). Then right click, and choose Format Cells from the context menu, and in the popping out Format Cells dialog box, click Protection tab, and uncheck the Locked option. ![]() The tutorial shows three different ways to hide rows in your worksheets. It also explains how to show hidden rows in Excel and how to copy only visible rows. If you want to prevent users from wandering into parts of a worksheet you don't want them to see, then hide such rows from their view. This technique is often used to conceal sensitive data or formulas, but you may also wish to hide unused or unimportant areas to keep your users focused on relevant information. On the other hand, when updating your own sheets or exploring inherited workbooks, you would certainly want to unhide all rows and columns to view all data and understand the dependencies. This article will teach you both options. • • • • • • • • • • • • • • • • How to hide rows in Excel As is the case with nearly all common tasks in Excel, there is more than one way to hide rows: by using the ribbon button, right-click menu, and keyboard shortcut. Anyway, you begin with selecting the rows you'd like to hide: • To select one row, click on its heading. • To select multiple contiguous rows, drag across the row headings using the mouse. Or select the first row and hold down the Shift key while selecting the last row. • To select non-contiguous rows, click the heading of the first row and hold down the Ctrl key while clicking the headings of other rows that you want to select. With the rows selected, proceed with one of the following options. Hide rows using the ribbon If you enjoy working with the ribbon, you can hide rows in this way: • Go to the Home tab > Cells group, and click the Format button. • Under Visibility, point to Hide & Unhide, and then select Hide Rows. Alternatively, you can click Home tab > Format > Row Height and type 0 in the Row Height box. Either way, the selected rows will be hidden from view straight away. Hide rows using the right-click menu In case you don't want to bother remembering the location of the Hide command on the ribbon, you can access it from the context menu: right click the selected rows, and then click Hide. Android studio. Excel shortcut to hide row If you'd rather not take your hands off the keyboard, you can quickly hide the selected row(s) by pressing this shortcut: Ctrl + 9 How to unhide rows in Excel As with hiding rows, Microsoft Excel provides a few different ways to unhide them. Which one to use is a matter of your personal preference. What makes the difference is the area you select to instruct Excel to unhide, only, or the in a sheet. Unhide rows by using the ribbon On the Home tab, in the Cells group, click the Format button, point to Hide & Unhide under Visibility, and then click Unhide Rows. Unhide rows using the context menu You select a group of rows including the row above and below the row(s) you want to unhide, right-click the selection, and choose Unhide in the pop-up menu. This method works beautifully for unhiding a single hidden row as well as multiple rows. For example, to show all hidden rows between rows 1 and 8, select this group of rows like shown in the screenshot below, right-click, and click Unhide: Unhide rows with a keyboard shortcut Here is the Excel Unhide Rows shortcut: Ctrl + Shift + 9 Pressing this key combination (3 keys simultaneously) displays any hidden rows that intersect the selection. Show hidden rows by double-clicking In many situations, the fastest way to unhide rows in Excel is to double click them. The beauty of this method is that you don't need to select anything. Simply hover your mouse over the hidden row headings, and when the mouse pointer turns into a split two-headed arrow, double click. How to unhide all rows in Excel In order to unhide all rows on a sheet, you need to select all rows. For this, you can either: • Click the Select All button (a little triangle at the upper left corner of a sheet, in the intersection of the row and column headings): • Press the Select All shortcut: Ctrl + A Please note that in Microsoft Excel, this shortcut behaves differently in different situations. If the cursor is in an empty cell, the whole worksheet is selected. But if the cursor is in one of contiguous cells with data, only that group of cells is selected; to select all cells, press Ctrl+A one more time. Once the entire sheet is selected, you can unhide all rows by doing one of the following: • Press Ctrl + Shift + 9 (the fastest way). • Select Unhide from the right-click menu (the easiest way that does not require remembering anything). • On the Home tab, click Format > Unhide Rows (the traditional way).
0 Комментарии
Оставить ответ. |