I just noticed that there is no "Y" column in a particular spreadsheet (see attached screen shot). Might anyone know why?
I just noticed that there is no "Y" column in a particular spreadsheet (see attached screen shot). Might anyone know why?
It's hidden (note the thicker line between the columns): select columns X and Z, right-click, unhide.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Duh! Thank you AliGW! Can individual cells be hidden as well?
Entire columns, or rows can be hidden, but not individual cells.
If you just want to hide the contents, change the font colour to match the fill colour, or use a custom format of ;;;
Good to know. Is there a way I can "lock" individual cells from accidental editing?
Yes, you can protect them
Ask if you need more info on that
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks