Hidden Columns/Rows

Mr. Guy

New Member
Joined
Mar 24, 2002
Messages
18
I had a document sent to me that only has columns A to Q visible and rows 1 through 100. The other rows and columns are not visible. I need to insert new rows and I get the following error:

To prevent possible loss of data, Microsoft Excel cannot shift nonblank cells off the worksheet.
Try to delete or clear the cells to the right and below your data. Then select cell A1, and save your workbook to reset the last cell used.

Or, you can move the data to a new location and try again.


Can someone please tell me how to make these columns and rows visible again?? I need to expand on this document.

Thanks
 

Excel Facts

Did you know Excel offers Filter by Selection?
Add the AutoFilter icon to the Quick Access Toolbar. Select a cell containing Apple, click AutoFilter, and you will get all rows with Apple

mikeprice53

Active Member
Joined
Jan 21, 2003
Messages
297
First off you need to unhide the cells you cannot see ( Drag the whole columns a couple before the hidden ones start and right click > unhide )

If the whole sheet is FULL of data it will give you that message because the limitations of excell will only allow up to Column "IV" and rows "65536" so if it is full your stuck really !

Only thing I can suggest is to unhide the lot and delete any data you see not neccasry to the form !

Good luck...
 

Greg Truby

MrExcel MVP
Joined
Jun 19, 2002
Messages
10,022
You can also search here for keywords relating to your problem. You're not the first person to ever see this problem. Example.

[Edit]To unhide, you can just hit F5 and GoTo IV1. The cursor will be hidden. Then hit Ctrl+Shift+0 to unhide. While in col IV, hold down your shift key, click on A1 (or Q1), hit Ctrl+Shift+0 again. Similiar process to unhide rows, but use Ctrl+Shift+9. [EndEdit]
 

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
60,755
Office Version
  1. 365
Platform
  1. Windows
Another note, to expand upon Mike Price's post.

Sometimes, it may appear that all the rows/columns are not used, but when you try to insert something, it says that there are no more rows/columns available.

This may happen when certain formatting/formulas have been applied on all cells. If you delete all the unnecessary rows/columns and save your file, you should then be able to insert rows/columns again.
 

Mr. Guy

New Member
Joined
Mar 24, 2002
Messages
18
Thanks for your help. Someone decided to put thier formulas in IV for some reason and excel wouldn't let me push that column out of the workbook.
 
Learn Excel from Bill Jelen

Understanding data is crucial, and the easiest place to start is with Microsoft Excel.

Forum statistics

Threads
1,151,560
Messages
5,765,095
Members
425,258
Latest member
brentmitchell

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top