There are a couple of tricks for unhiding, but I’ve found most users forget them because they don’t use them often enough to commit them to memory. Then, choose Row or Column from the Format menu, and select Unhide. In Excel 2003, use the Name Box to select cell A1. Then, select Unhide and Excel will expose the hidden row or column. Next, click the Format dropdown in the Cells group (on the Home tab) and choose Hide & Unhide. Excel will select cell A1, but you won’t see that happen, because the cell’s hidden. When row 1 or column A is hidden, enter A1 in the Name Box, and press Enter. It’s a simple task, but a problem arises when you want to unhide row 1 or column A because there’s no row or column above or to the left, respectively. Use the same process to unhide multiple non-contiguous rows and columns as you would a single row or column, just select a larger range. In the sheet below, I selected columns C and E to unhide column D. Select the adjacent columns or rows, right-click, and select Unhide from the resulting context menu. You can quickly discern that a row or column is hidden by the missing header. Unhiding is also simple. In Excel 2003, choose Column or Row from the Format menu, and then select Hide. To hide a row or column, you click the header to select the entire row or column, right-click the selection, and choose Hide from the resulting context menu. To hide multiple noncontiguous rows or columns, select the rows or columns and choose Hide & Unhide from the Format dropdown in the Cells group.
#UNHIDE A COLUMN IN EXCEL 2003 HOW TO#
Today, I’ll show you how to unhide row 1 and column A.įirst, let’s run through the instructions for hiding and unhiding rows and columns, just in case this task is new to you. When unhiding a row or column, you select the adjacent rows or columns, but there’s no row above row 1 or column to the left of column A, which presents a bit of a conundrum. So right click the column and select UnHide option. As we already know this example, i want to unhide the Column F and G again. Once you select UnHide, the selected column will be shown. Then right click the column and select UnHide from the drop down box.
Hiding and unhiding rows and columns is a straightforward and easy task, unless you’re trying to unhide row 1 or column A. Highlight the column on either side of the hidden column which you want to unhide. I dont need to re-hide the rows later - I just need to unhide it so that when I copy a column it copies all cells (including hidden ones). This week the client sent another Excel file with hidden rows, but I cant remember how I unhid the rows last week. Learn an easy to remember method for unhiding row 1 and column A. Last week a client sent me an Excel file with hidden rows that I was able to unhide. The typical unhiding techniques don't work everywhere in Excel. How to unhide row 1 and column A in an Excel sheet
0 kommentar(er)
