LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 262
Default Excel table setup

I have a table setup on Sheet 1 using Col A - Q and rows 1 - 21 the first
four rows have heading detail. My question is this:
I want the same layout to appear as I go down through the sheet so that when
I have inputted data in the rows 5 - 21 I have the same table again below say
starting in row 23. Is there a way to repeat the table throughout the sheet
multiple times without copy/paste. I have tried freezing panes and the page
setup / sheet tab but these don't produce the required effect. Thanks
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Data table setup Karl K. Excel Worksheet Functions 1 November 1st 07 02:41 PM
how do you setup a table Daryl Excel Worksheet Functions 2 April 17th 06 11:53 PM
Vook Up Table - how to setup eagle Excel Discussion (Misc queries) 1 December 11th 05 05:33 PM
How to setup a look up table where the lookup_value comes from tw. Booner Excel Discussion (Misc queries) 1 April 22nd 05 11:57 PM
how do I setup an excel table that outlines the face of a standar. Fred Wenzler Excel Discussion (Misc queries) 0 April 13th 05 03:35 AM


All times are GMT +1. The time now is 04:13 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"