ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Viewable columns (https://www.excelbanter.com/excel-discussion-misc-queries/167436-viewable-columns.html)

BruceC

Viewable columns
 
Is there a way to eliminate the colums on a spreadsheet that you do not need.
I have employees use spreadsheet in our office who are not Excel users and
end up entering data in colums not used in the spreadsheet. If I use column
a-f, how can I hav all columns past f through... not appear on my screen

Thank you
Bruce

robert morris

Viewable columns
 
Bruce,

Click on "Help", then type in "hide columns" in the search box. It is all
very easy. Need more help after that, reply to me. What version of excell
are you using?

Bob M.



"BruceC" wrote:

Is there a way to eliminate the colums on a spreadsheet that you do not need.
I have employees use spreadsheet in our office who are not Excel users and
end up entering data in colums not used in the spreadsheet. If I use column
a-f, how can I hav all columns past f through... not appear on my screen

Thank you
Bruce


Mike Rogers[_2_]

Viewable columns
 
BruceC

Select them and "Hide" them.

Mike Rogers

"BruceC" wrote:

Is there a way to eliminate the colums on a spreadsheet that you do not need.
I have employees use spreadsheet in our office who are not Excel users and
end up entering data in colums not used in the spreadsheet. If I use column
a-f, how can I hav all columns past f through... not appear on my screen

Thank you
Bruce



All times are GMT +1. The time now is 03:36 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com