Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 54
Default Insert rows: Formats & formulas extended to additonal rows

If anyone can assist, I'd be most grateful.
Firstly, Extend Formats & Formulas to Additional Rows is checked in Oprions
under the Tools menu.
BUT, as well as extending formats & formulas (which is really useful and I
want to keep this facility), links to info sources from the row below are
also collected and implanted into the newly inserted row (using the Insert
drop down menu), which isn't useful and will cause major problems with
spreadsheet results. Is there a different box which needs to be checked or
some other measure which will sort thisout for me?
Reply
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
Insert rows without effecting formulas [email protected] Excel Worksheet Functions 1 September 10th 07 08:53 AM
Insert rows with Formulas Doug Manning Excel Discussion (Misc queries) 0 September 16th 05 05:33 PM
How to have formulas and formats auto copy to new inserted rows DippyDawg Excel Discussion (Misc queries) 2 August 5th 05 03:09 PM
Copy/Insert rows with formulas GregR Excel Worksheet Functions 4 April 26th 05 10:29 PM
INSERT ROWS WITHOUT SCREWING-UP FORMULAS! BILL GATES - I WANNA WORD WITH YOU! Excel Worksheet Functions 1 March 4th 05 02:32 PM


All times are GMT +1. The time now is 04:38 PM.

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"