Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel : F2-F4 in multiple sheets should have independent result
How extremely lame. A 'relative' action such as F2-F4 (toggle
relative/absolute cell references), on a cell across multiple highlighted sheets, results in all sheets having the result from the current sheet. Do kindergarten children programme for MS, because this is so inept it isn't funny. eg. If, 'Sheet 1'!C45 = M55 and 'Sheet 2'!C45 = B23 then after F2, F4 the results should be $M$55 and $B$23, NOT $M$55 for both. Use your brains that God gave you guys,... this is so obvious! ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/comm...lic.excel.misc |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
multiple sheets when importing into excel | Excel Worksheet Functions | |||
spell number | Excel Worksheet Functions | |||
Opening multiple Excel files that contain varied selected sheets | Excel Worksheet Functions | |||
saving excel with multiple sheets, but won't save to proper sheet | Excel Discussion (Misc queries) | |||
Updating Excel Data on Multiple Sheets | Excel Worksheet Functions |