Get instant live expert help on I need help with scrollable table with fixed header and first column

“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

Here are some problems that our users have asked and received explanations on

When I scroll down i wont see the header, so can header be fixed?? so that when I scroll down i should see the header
Solved by V. J. in 18 mins
I have a table of ALL employee transactions. In the first column is the employee name. In the second column is the transaction amount. I have a second table with employee names organized by shift. The first column header is "Morning Shift" and below it is a list of the morning shift employee names. The second column header is "Evening Shift" and below it is a list of the evening shift employee names. I want a formula that will sum all of the transactions by morning shift employees. Please help
Solved by C. H. in 20 mins
Create a New Table Style named Academic Team Schedule. Format the First Row Stripe using the Fill tab and in the sixth column, click the third color. Format the Second Row Stripe using the sixth column, fifth color. Format the Header Row using the eighth color in the first row. Set as the default table style for this document.
Solved by S. F. in 20 mins
sir i have single column data in which i want to paste my one particular data of column step by step in different fixed place of separate separate worksheet. example i have ten names in single column and i want first name in first sheet and second name in second sheet and so on in a fixed place of each sheet
Solved by X. Q. in 11 mins
Hi, I'm trying to dynamically link a cell (specifically a column header) in Table B to a column header cell in Table A on another worksheet in Excel. I'm using structured referencing which is returning '0' as text when I complete the formula (and the formula disappears). I've tried both typing the formula and creating it by typing = and clicking on the cell I want to link to. If the title of the column header in Table A changes, I need that change to be reflected in the relevant column header in Table B too. I've been searching forums for the solution but haven't found it yet!
Solved by S. D. in 24 mins