A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » General Discussion
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Fill down visible cells only



 
 
Thread Tools Display Modes
  #1  
Old April 23rd, 2009, 02:02 PM posted to microsoft.public.excel.misc
Stefi
external usenet poster
 
Posts: 1,841
Default Fill down visible cells only

Hi All,

I have a subtotalled sheet, only subtotal rows are visible. I entered a
formula in the 1st subtotal row and I'd like to fill it down through subtotal
rows only. Is there a simple way (in Excel2007)? Dragging is not good because
it effects the hidden rows, too.

Thanks,
Stefi
  #2  
Old April 23rd, 2009, 02:24 PM posted to microsoft.public.excel.misc
eduardo
external usenet poster
 
Posts: 2,131
Default Fill down visible cells only

Hi Stefi,
make copy, then select the range , press AltG, special, select visible cells
only, then paste

If this helped please say yes, thanks

"Stefi" wrote:

Hi All,

I have a subtotalled sheet, only subtotal rows are visible. I entered a
formula in the 1st subtotal row and I'd like to fill it down through subtotal
rows only. Is there a simple way (in Excel2007)? Dragging is not good because
it effects the hidden rows, too.

Thanks,
Stefi

  #3  
Old April 23rd, 2009, 02:38 PM posted to microsoft.public.excel.misc
Stefi
external usenet poster
 
Posts: 1,841
Default Fill down visible cells only

Thanks Eduardo, your way partly does the job, but 2 problems remain:
1. It overwrite the header (row 1) as well,
2. It fills ALL rows (it's more than 1 million in Excel 2007).

Any further idea?
Regards,
Stefi

„Eduardo” ezt *rta:

Hi Stefi,
make copy, then select the range , press AltG, special, select visible cells
only, then paste

If this helped please say yes, thanks

"Stefi" wrote:

Hi All,

I have a subtotalled sheet, only subtotal rows are visible. I entered a
formula in the 1st subtotal row and I'd like to fill it down through subtotal
rows only. Is there a simple way (in Excel2007)? Dragging is not good because
it effects the hidden rows, too.

Thanks,
Stefi

  #4  
Old April 23rd, 2009, 02:47 PM posted to microsoft.public.excel.misc
eduardo
external usenet poster
 
Posts: 2,131
Default Fill down visible cells only

Hi Stefy,
One question with your subtotals the first one will not start in row1 so
select only the range with subtotals, I tested it and worked

"Stefi" wrote:

Thanks Eduardo, your way partly does the job, but 2 problems remain:
1. It overwrite the header (row 1) as well,
2. It fills ALL rows (it's more than 1 million in Excel 2007).

Any further idea?
Regards,
Stefi

„Eduardo” ezt *rta:

Hi Stefi,
make copy, then select the range , press AltG, special, select visible cells
only, then paste

If this helped please say yes, thanks

"Stefi" wrote:

Hi All,

I have a subtotalled sheet, only subtotal rows are visible. I entered a
formula in the 1st subtotal row and I'd like to fill it down through subtotal
rows only. Is there a simple way (in Excel2007)? Dragging is not good because
it effects the hidden rows, too.

Thanks,
Stefi

  #5  
Old April 23rd, 2009, 02:52 PM posted to microsoft.public.excel.misc
eduardo
external usenet poster
 
Posts: 2,131
Default Fill down visible cells only

Hi Stefi,
Another thing be sure you select Visible cells , it should be copying the
formula into the subtotal rows,
Wait a minute I know what happens, select to see only the subtotals # 2 in
your left upper and then do what I told you

"Stefi" wrote:

Thanks Eduardo, your way partly does the job, but 2 problems remain:
1. It overwrite the header (row 1) as well,
2. It fills ALL rows (it's more than 1 million in Excel 2007).

Any further idea?
Regards,
Stefi

„Eduardo” ezt *rta:

Hi Stefi,
make copy, then select the range , press AltG, special, select visible cells
only, then paste

If this helped please say yes, thanks

"Stefi" wrote:

Hi All,

I have a subtotalled sheet, only subtotal rows are visible. I entered a
formula in the 1st subtotal row and I'd like to fill it down through subtotal
rows only. Is there a simple way (in Excel2007)? Dragging is not good because
it effects the hidden rows, too.

Thanks,
Stefi

  #6  
Old April 23rd, 2009, 02:55 PM posted to microsoft.public.excel.misc
Stefi
external usenet poster
 
Posts: 1,841
Default Fill down visible cells only

Selecting first B2:Bn (n is row No of last subtotal) via Goto, then following
with selecting visible cells it worked, thank you! Microsoft should provide a
new feature in filling: Fill visible cells only!
Stefi


„Eduardo” ezt *rta:

Hi Stefy,
One question with your subtotals the first one will not start in row1 so
select only the range with subtotals, I tested it and worked

"Stefi" wrote:

Thanks Eduardo, your way partly does the job, but 2 problems remain:
1. It overwrite the header (row 1) as well,
2. It fills ALL rows (it's more than 1 million in Excel 2007).

Any further idea?
Regards,
Stefi

„Eduardo” ezt *rta:

Hi Stefi,
make copy, then select the range , press AltG, special, select visible cells
only, then paste

If this helped please say yes, thanks

"Stefi" wrote:

Hi All,

I have a subtotalled sheet, only subtotal rows are visible. I entered a
formula in the 1st subtotal row and I'd like to fill it down through subtotal
rows only. Is there a simple way (in Excel2007)? Dragging is not good because
it effects the hidden rows, too.

Thanks,
Stefi

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 09:26 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright 2004-2024 OfficeFrustration.
The comments are property of their posters.