Tip: Other languages are Google-Translated. You can visit the English version of this link.
Log in
x
or
x
x
Register
x

or

How to show hidden first column or row in Excel?

In general, you can select the cells which are on the hidden column or row’s either sides, and then click Home > Format > Hide & Unhide to display the hidden column or row as below screenshot shown. However, if the first column or row whose two sides’ cells you cannot select is hidden, how can you display such column or row in Excel?
doc shown hidden first row column 1

Show hidden first column/row with Go To function

Show hidden first column/row with Kutools for Excel good idea3

Enable you to do smarter, faster and better

Kutools - the best office productivity tool brings 300 advanced features to Excel. Details... Download...

Office Tab - brings tabbed interface to Excel and Word, make your work much easier. Details...Download...


arrow blue right bubble Show hidden first column/row with Go To function


To show hidden first column or row, you need to use Go to function to locate in A1, and then display the row or column.

1. Enable the sheet you want to display the first column or row, and press Ctrl + G to open Go To dialog, and enter A1 into the Reference textbox. See screenshot:
doc shown hidden first row column 2

2. Click OK to locate in A1, and then click Home > Format > Hide & Unhide > Unhide Columns/ Unhide Rows. See screenshot:
doc shown hidden first row column 3

Then the first column or row has been unhidden.


arrow blue right bubble Show hidden first column/row with Kutools for Excel

If you have Kutools for Excel, its Unhide All Ranges utility can quickly unhide all hidden columns and rows.

Kutools for Excel, with more than 120 handy Excel functions, enhance your working efficiency and save your working time.

Enable the sheet you want to show all hidden ranges, and click Kutools > Show/Hide > Unhide All Ranges. See screenshot:
doc shown hidden first row column 4

Now all hidden ranges have been shown.

doc download 1



Excel Productivity Tools

Kutools for Excel - The Best Office Productivity Tool

  • Brings 300 powerful advanced features to Excel, enable you to do smarter, faster and better.
  • No longer need memorizing formulas and VBA codes, give your brain a rest from now on.
  • Become an Excel expert in 3 minutes, Complicated and repeated operations can be done in seconds, 
  • Reduce thousands of keyboard & mouse operations every day, say goodbye to occupational diseases now.
  • 110,000 highly effective people and 300+ world-renowned companies' choice.
  • 60-day full features free trial. 60-day money back guarantees. 2 years of free upgrade and support.

Office Tab - brings tabbed interface to Office, make your work much easier.

  • Enable tabbed editing and reading in Word, Excel, PowerPoint, Publisher, Access, Visio and Project.
  • Open and create multiple documents in new tabs of the same window, rather than in new windows.
  • Increases your productivity by 50%, and reduces hundreds of mouse clicks for you every day!
Say something here...
symbols left.
You are guest ( Sign Up? )
or post as a guest, but your post won't be published automatically.
Loading comment... The comment will be refreshed after 00:00.

Be the first to comment.