Hover the mouse over column B’s header cell and move left.Now, choose Column from the Format menu, and the choose Unhide. Doing so will selecteverything to the left, including column A. Release the mouse with the pointer over the Select All cell (the blank gray cell that intersects the header and row cells). Don’t click any borders, just drag the selection mouse pointer (the fat arrow pointing down). Click column B’s header cell and drag the mouse pointer to the left.Don’t panic, column A isn’t gone forever, and there’s more than one way to unhide it: Selecting just column B won’t select column A. That works fine until you try to unhide column A, as there’s only one adjacent column, column B. After selecting the hidden column and its adjacent columns, choose Column from the Format menu and then select Unhide. You’re really selecting three columns: the hidden column and both columns on either side of it. Select the columns that are adjacent to the hidden column. Unhiding a column takes a bit of specialized knowledge, but it isn’t difficult. You can also check out previously reviewed guides on Tracking Formula Precedents & Dependents and Show complete formula instead of Evaluated Result in Excel 2010. To hide a column, select it, choose Column from the Format menu, and then select Hide. For revealing the hidden sheets, rows and columns, click Format, and from Hide & Unhide options, click the respective option available in the menu. Maximum number of line feeds per cell: 253 lines feeds. Characters in a header or footer: 255 characters.
Total number of characters that a cell can contain: 32,767 characters. SEE: Download: Build your Excel skills with these 10 power tips (TechRepublic) Page breaks: 1,026 horizontal and vertical.
Hiding a column tucks data out of sight without interfering with its function. Even you won’t want to see all of it all the time. Confidentiality aside, sometimes endless data is just a nuisance. Not everything in your worksheet needs to be privy to everyone. Fortunately, there are two simple tricks for unhiding it. If you release the mouse button when the pointer is over the gray block that marks the intersection of the row and column headers (the. Another way to display the first column is to click on the header for column B, and then drag the mouse to the left. The secret to unhiding column A in an Excel worksheetĪfter you hide column A, it might seem like it's gone forever. Click the Format tool in the Cells group, then choose Hide & Unhide, then Unhide Columns.