Your mouse cursor will turn into a double-sided arrow icon. Hover the mouse cursor over the top border of the first visible row label or the left border of the first visible column.How can you show this hidden row or column again? This is very easy with the first method.įollow these steps to unhide the first row or column with a click and drag. This can be seen as a small space between the row or column and the select all button at the intersection of the row and column headings. There will also be a small visual indicator on the row or column heading to show the first row or column is hidden. You will know the sheet has the first row or column hidden if the top leftmost cell only shows row label 2 or column label B. If you land on row 2 or column B, you will know the first row or first column has been hidden. If you press Ctrl + Home, this will take you to the first visible cell in the sheet. Hiding the first row or column is very common, but can be tricky to undo since the usual tactics don’t work.
#Excel ze top row and first column how to
But this won’t work since there is no row above row 1 and no column before column A.īut there are other methods! Follow this post if you want to learn how to show row 1 and column A again! Unhide the First Row or First Column with a Click and Drag The usual method to unhide a row or column is to select a set of rows or columns containing the hidden row or column and then use the appropriate Unhide command. Not all methods to unhide will work for row 1 and column A! There are many ways to unhide rows or columns when you want them back, but unhiding the first row or the first column in your sheet can be tricky. Hidden rows and columns are a common technique in Excel to temporarily remove focus on certain data in your sheet. Is the first row or first column hidden from your sheet and do you want to show it? This post is going to show you all the ways you can unhide row 1 or column A in Microsoft Excel.
0 kommentar(er)
