2 questions. splitting a LONG workbook, and simplying a COLA calculation.

  • Thread starter Thread starter G.T.W.
  • Start date Start date
G

G.T.W.

First,

I'm new to Excel, and can not get the paperclip to explain this to me.

I have been working on the same page in an Excel workbook, the row
count is getting into the 300s . The information is not all related,
and I wish I could segment this one long page into page 2, page 3,
etc. How can I do this?

Second,

I have created a Cost of Living Allowance based upon an initial
salary, then added a 4.4% Annual increaase over a 5 year period. It
basically looks like this

Initial I Cola I 2ndYR I Cola I 3rdYR I Cola I 4thYR I Cola I 5thYR

It exceeds the width of my page. My equations are straight addition
from one YR plus COLA adding into the next YR column. Of course, when
I tried to compact the columns, I got all ########s,and attempting to
remove the COLA columns negates the equations. Is there a simpler,
more compact way to do COLA over the same period without having to
resort to merely copying the numbers to a non-equation-based table?
Thank you.
 
1. One option is to put your related information in separate worksheets. At
the bottom of your spreadsheet, you will have a tab that likely says
"Sheet1". Right-click on this and insert a new sheet. Then cut and paste the
rows you want from Sheet1 to Sheet2.

2. When you get ###'s it means there's not enough room to display the result
in the format you requested. The best option is to reformat the numbers. Do
you need pennies displayed? If not, that always saves a lot of room. Do you
need the commas or $ displayed? See if you can format the number to an
acceptable format. If not, post back with your formula and what you want
displayed, and we'll find a way.
 
Thank you Fred. Your suggestion did the trick for item # 1

Excel figured out my intent on item #2. After entering my COLA
equation for the first row (first employee). I extended the result
column down to the next row as a quick way of copying the whole line.
I figured I would have to just re-organize the COLA numbers for each
employee, but Excel correctly translated the columns so that I only
had to do it once. I love it when a spreadsheet works!
 
Back
Top