hi all.
i have word document contains table and text with over 9 pages.
how to edit /update table with easy, cause since i go down to page 2, 3,4, etc...that make confuse cause the header not always showing.
how to make header always showing like Freeze Panes in Excel to be "helper" inputting data or how to tricks for this case
here the attachment file
maybe this step:
1. select range that you want to be header;
2. run macro, like "Freeze Panes" is showing
the header is blue shading
anyone help me, thanks in advance
.susant
VBA:Showing Header Table Like Freeze Panes in Excel
-
- 3StarLounger
- Posts: 240
- Joined: 17 Feb 2022, 05:16
VBA:Showing Header Table Like Freeze Panes in Excel
You do not have the required permissions to view the files attached to this post.
-
- Administrator
- Posts: 12604
- Joined: 16 Jan 2010, 15:49
- Location: London, Europe
Re: VBA:Showing Header Table Like Freeze Panes in Excel
You already have "Repeat header rows" set so that this table head will appear on every page.
You might be able to achieve what you want by moving the table header to the top of the screen and using View > Split to create a separate pane that has just the table headers at the top of the screen.
You might be able to achieve what you want by moving the table header to the top of the screen and using View > Split to create a separate pane that has just the table headers at the top of the screen.
You do not have the required permissions to view the files attached to this post.
StuartR
-
- 3StarLounger
- Posts: 240
- Joined: 17 Feb 2022, 05:16
Re: VBA:Showing Header Table Like Freeze Panes in Excel
hi StuartR...
thank you so much!
thank you so much!