Excel rows and columns greyed out

Question

Normally I use Excel 2003 without problem apart from a problem with one particular spreadsheet.

This spreadsheet has been completed in full with data entered in all the appropriate columns and rows.

However I now find that some of the rows/columns in the lower part of the spreadsheet have been greyed out. I don't know how this happened.

Now when I want to print the spreadsheet it only prints that part which is not greyed out. The rest I have to highlight and print as a selection. How can I overcome this problem.

Thank you

Answer 1

1. CTRL+A to select entire worksheet.
2. Right click on any row number and take unhide.
3. Right click on any column number and take unhide.

Answer 2

Thanks for that but it's not working.

Answer 3

Thanks for this. I do not have one drive and am reluctant to sign up for just this issue. Thank you for your interest. I shall have to research another solution. Regards

Answer 4

Without looking at your file. it is difficult to say anything..Can the file shared at onedrive, if it doesn't contain sensitive data. You may probably delete the data and upload as data doesn't matter for your problem...

To upload to onedrive -

1. Login to https://onedrive.live.com/
2. Open the public folder.
3. Click Upload in the top.
4. After uploading, right click it and choose share.
5. Click Get a Link.
6. In the option, choose public.
7. Create Link
8. Post the link here.