Ask a new question

Excel rows and columns greyed out

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

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.

Sincerely yours,
Vijay A. Verma | Blogging @ https://excelbianalytics.com | Linkedin @ https://www.linkedin.com/in/excelbi/

6 people found this reply helpful

·

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

Thanks for that but it's not working.

2 people found this reply helpful

·

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

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.

Sincerely yours,
Vijay A. Verma | Blogging @ https://excelbianalytics.com | Linkedin @ https://www.linkedin.com/in/excelbi/

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

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

1 person found this reply helpful

·

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

 
 

Question Info

Last updated April 13, 2025 Views 25,349 Applies to: