Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Missing row
A user has deleted a row that had an amount in it. Her rows are now number,
23, 24, 25, 27 (so row 26 is missing). Whenever she tries to total columns or rows, the number that is in that missing row is calculated in. How do I retrieve that row, or clear out the number? TIA. Kim |
#2
|
|||
|
|||
Select rows 24 and 26, the whole rows and goto FormatRowUnhide.
-- HTH RP (remove nothere from the email address if mailing direct) "Kim" wrote in message ... A user has deleted a row that had an amount in it. Her rows are now number, 23, 24, 25, 27 (so row 26 is missing). Whenever she tries to total columns or rows, the number that is in that missing row is calculated in. How do I retrieve that row, or clear out the number? TIA. Kim |
#3
|
|||
|
|||
Good evening Kim Your user has either set the row height to 0, or hidden the row (a hidden row is basically the same). Highlight rows 25 and 27 and right click. In the menu that drops down there should be an option to "Unhide". Select this and the row should be visible again. HTH DominicB -- dominicb ------------------------------------------------------------------------ dominicb's Profile: http://www.excelforum.com/member.php...o&userid=18932 View this thread: http://www.excelforum.com/showthread...hreadid=396953 |
#4
|
|||
|
|||
Hi Kim,
Don't understand what you have and what you have in the row, but would you right click on the sheet tab and see if you have code there other than Option Explicit at the top. --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "Kim" wrote in message ... A user has deleted a row that had an amount in it. Her rows are now number, 23, 24, 25, 27 (so row 26 is missing). Whenever she tries to total columns or rows, the number that is in that missing row is calculated in. How do I retrieve that row, or clear out the number? TIA. Kim |
#5
|
|||
|
|||
I saw the light or at least the other answers after I sent off my reply.
Both the fact that there were other answers and that the row was hidden or filtered out should have been obvious to me. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Missing title bar? | Excel Discussion (Misc queries) | |||
interpolate missing data between points | Excel Worksheet Functions | |||
missing data from table | Excel Discussion (Misc queries) | |||
missing data from table | Excel Discussion (Misc queries) | |||
Missing values in Excel Line Chart | Charts and Charting in Excel |