subtotal

skalavati · Apr 18th, 2002, 12:01 AM

i want to select only the subtotal rows without using the ctrl key.

Chris Davison · Apr 18th, 2002, 12:34 PM

is the "subtotal" function invoked ?

ie : to the left of your spreadsheet, do you have a list of [1], [2], [3] etc etc and some odd-looking lines ?

IML · Apr 18th, 2002, 12:37 PM

If I understand you, you can collapse your subtotal, highlight it, hit control G, special, visable cells only to copy, etc.

Also, consider using consolidate under data.

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

Apr 18th, 2002, 12:01 AM	#1
skalavati Board Regular Join Date: Apr 2002 Posts: 55	i want to select only the subtotal rows without using the ctrl key.

Apr 18th, 2002, 12:34 PM	#2
Chris Davison MrExcel MVP Join Date: Feb 2002 Location: Millbank, London, UK Posts: 1,790	is the "subtotal" function invoked ? ie : to the left of your spreadsheet, do you have a list of [1], [2], [3] etc etc and some odd-looking lines ?

Apr 18th, 2002, 12:37 PM	#3
IML MrExcel MVP Join Date: Feb 2002 Location: Denver, CO Posts: 1,744	If I understand you, you can collapse your subtotal, highlight it, hit control G, special, visable cells only to copy, etc. Also, consider using consolidate under data.