Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 5
Default How can I use formula and format as it is, in the next rows?

How can I use formula and format as it is, in the next rows?
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default How can I use formula and format as it is, in the next rows?

Select the cell whose format you want to apply to the other cells, and copy
it (either Ctrl+C or Edit/Copy from the menu), select the cells you want to
apply the format to and select Edit/PasteSpecial from the menu... select
Formats and click OK.

Rick



"Niranjan" wrote in message
...
How can I use formula and format as it is, in the next rows?


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Conditional Format of Odd Visible Rows mjones Excel Discussion (Misc queries) 1 November 20th 06 12:17 AM
conditional format rows Excel Challenged Excel Discussion (Misc queries) 1 January 24th 06 06:41 PM
can't format rows to autofit jbf Excel Discussion (Misc queries) 2 January 21st 06 11:54 PM
How do I format Excel to add new rows automatically? sassecathy Excel Worksheet Functions 2 December 8th 05 02:15 AM
how to format pull down rows pjh Excel Worksheet Functions 1 November 8th 04 07:01 PM


All times are GMT +1. The time now is 04:06 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"