• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 185
  • Last Modified:

Extend checking account page when it runs out

http://www.pixentral.com/show.php?picture=1bhJk5fwmMdXueCbCYcGBFblyjwmM

Is there a simple way to extend this checkbook worksheet page, with all the same formatting, in a single operation?
0
mikecox_
Asked:
mikecox_
  • 6
  • 4
1 Solution
 
MatG23Commented:
Hi,

Highlight rows 68 and 69 completely. Go to the row heading for 69 (the light blue box in your picture). If you move your mouse slightly right of the bottom right corner of the light blue 69 box, your cursor should change to a cross. Once you have the cross, hold the left mouse button and drag down. This will copy formats and your number series down.

Matt
0
 
mikecox_Author Commented:
Did you mean "slightly left of the bottom left corner"?  

When I went to the bottom right; which produced a cross with arrowheads on it's ends,  the result was to copy the 2 highlighted rows to a new location.

When I tried the Left corner; which created a plane cross, it worked.
0
 
mikecox_Author Commented:
Sorry about all that junk; something to do with Firefox.  Still working on a fix.
0
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
MatG23Commented:
When you see the cross with arrowheads, move your mouse a little right. You should see a slightly smaller cross that is the same length horizontal & vertical. When you have rows 68 & 69 completely highlighted, which includes highlighting the row number heading boxes, you should see a very tiny black box in the bottom right corner of the 69 row header box. place your mouse cursor over that. Once your mouse cursor is exactly on top of that little black box it will change to the cross shape. When you have the cross shape, click and hold the left mouse button and drag down.
0
 
mikecox_Author Commented:
http://www.pixentral.com/show.php?picture=1YV5lx4ze3YDIgC3CNvl5jzR9xlcy3

I don't mean to belabor this point but on my system that little box is in the bottom left corner and when I place the cursor over it the big cross changes to a small cross.

Could this be a version issue? After getting my 64-bit system I purchased the newest version of Office.  I can't find the "About" info any more because the new toolbar is radically different from the old version I was using and I haven't sorted out all the options the  
0
 
mikecox_Author Commented:
Crap!  I forgot to switch to IE; sorry.
0
 
MatG23Commented:
I'm using excel 03, but I think all recent versions are the same. Please take a look at the attached file.
Excel-Row-Select.doc
0
 
mikecox_Author Commented:
You said: "move your mouse slightly right of the bottom right corner of the light blue 69 box" The box; the field, not the row ID
The "light blue box" in column A displays the little box in the bottom left corner.  I just don't see how you can discribe it as in the Right corner; even your attached file shows it in the the left corner of the box which is in column A.
Your description only fits if your ref point it the row ID, which in your example is 7.  From that perpective the little box is to the right of it, but it's still in the left corner of the field being dragged.
I just can't figure out why you insist in saying the little box is in the right corner; unless...:
Do you refer to the "Post Comment / Solution" in the title of this window as being in the upper right hand corner?
0
 
MatG23Commented:
Sorry for the confusion. I probably should not have referred to the box as the "light blue box". Your right, I should have referred to the row id, which is what I meant.
0
 
mikecox_Author Commented:
Perfect solution but confusing due to description of where to find the little box.
0

Featured Post

How to Use the Help Bell

Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention.  Check out this how-to article for more information.

  • 6
  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now