Hidden Data When Using Subtotals

Mac · May 22nd, 2002, 03:32 PM

I use the subtotal function on the data menu. I usually use the sum option to calculate numeric data. However, I need alpha data that isn't included in the subtotals. Is there any way to quickly copy the line above each subtotal line? I currently enter =A1 to copy the data to the subtotal line in A2. I then highlight the data in line A2 and use the Control key to highlight each subtotal line to copy the formula. Any suggestions will be greatly appreciated. Thank you!

IML · May 22nd, 2002, 03:37 PM

If you want to do this for one row, you make use of goto special under the edit menu (or control G. Collapse your subtotal list, copy your formula, highlight the column, hit control G, special, visable cells only, okay, and finally control V to paste. good luck

Mac · May 22nd, 2002, 03:53 PM

IML, Thank you very much for your suggestion! It worked as you said. Thanks again.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 22nd, 2002, 03:32 PM	#1
Mac New Member Join Date: May 2002 Posts: 2	I use the subtotal function on the data menu. I usually use the sum option to calculate numeric data. However, I need alpha data that isn't included in the subtotals. Is there any way to quickly copy the line above each subtotal line? I currently enter =A1 to copy the data to the subtotal line in A2. I then highlight the data in line A2 and use the Control key to highlight each subtotal line to copy the formula. Any suggestions will be greatly appreciated. Thank you!

May 22nd, 2002, 03:37 PM	#2
IML MrExcel MVP Join Date: Feb 2002 Location: Denver, CO Posts: 1,744	If you want to do this for one row, you make use of goto special under the edit menu (or control G. Collapse your subtotal list, copy your formula, highlight the column, hit control G, special, visable cells only, okay, and finally control V to paste. good luck

May 22nd, 2002, 03:53 PM	#3
Mac New Member Join Date: May 2002 Posts: 2	IML, Thank you very much for your suggestion! It worked as you said. Thanks again.