View Single Post
 
Old 12-12-2020, 12:56 AM
skoz55 skoz55 is offline Windows 7 64bit Office 2010 64bit
Novice
 
Join Date: Jan 2009
Posts: 20
skoz55 is on a distinguished road
Default Floating Table???

Hi,

I'm looking for some ideas on how to accomplish a task. I am a contractor and write my project Scope of Works in Excel. The beginning section of my SOW contains all the project calculations that my proposal is based off (ceiling height, floor area, etc.) I've created a spreadsheet that has many 26 columns that covers the 8.5" page, so each column is 2.5 wide. I then merge cells for the actual verbiage of the scope. This has allowed me to place all of my calculations in an organized and compact area because I have multiple columns as to where I can place them. (Ref tab Multi Columns on attached spreadsheet).

This works for formatting my calculations section; however, is a pain in many other areas in the Scope of Work because there are so many merged cells.

I've determined it's worth it to go back to making the columns as wide as they need to be and to eliminate the merged cells. Now I'm looking for a solution as to how to input my Project Calculations section. (Ref tab Min Columns on attached spreadsheet).

And ideal solution is if I could make a "floating table" of some kind that can have many narrow columns and I could place it wherever I want it. I've found ideas such as Edit > Copy Picture where I can place an image where I want it, but this causes other issues.

Any thoughts or ideas as to how to eliminate the need for tons of merged cells, but yet be able to have a section up top that it tight and compact?

Thanks
Attached Files
File Type: xlsx Floating Table.xlsx (21.0 KB, 17 views)
Reply With Quote