hello everyone
I have a spread sheet with a table which has column headers what I want to do is when I scroll page I want to make these headers appear in column labels.
Cell A1, B1, C1, etc above you have column labels A,B,C etc. When I scroll page I want my table headers to appear here
Hi there,
convert Your data to table. Select Your data and go to tab Insert -> Table or press Ctrl+T.
When You are clicked in You data table and scroll down, col. headers will appear in the col.names.
(works in excel 2007+)
Regards
Miroslav R.
(If You like my solutions, feel free to add reputation.)
Thank you Miroslav R
How do you hide the drop down button on side?
Hi there,
if You mean the filter buttons on each column, simple disable autofilter (Data tab & Filter, or Alt+A+T).
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks