Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default how can i use the = to move formatting and content between tabs?

I am trying to use the = sign to bring the exact content from cells in
another tab to another tab (data, colors, formatting, formulas, etc).

is this possible?
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 492
Default how can i use the = to move formatting and content between tabs?

It will give you only the value in the cell, it won't tell you the formula
(if any) or transfer the formatting.
Regards,
Alan.
"Need Excel help!" <Need Excel wrote in
message ...
I am trying to use the = sign to bring the exact content from cells in
another tab to another tab (data, colors, formatting, formulas, etc).

is this possible?


  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 22,906
Default how can i use the = to move formatting and content between tabs?

Not possible with a simple linking of cells.

Linking brings content only.


Gord Dibben MS Excel MVP

On Sat, 11 Apr 2009 14:05:01 -0700, Need Excel help! <Need Excel
wrote:

I am trying to use the = sign to bring the exact content from cells in
another tab to another tab (data, colors, formatting, formulas, etc).

is this possible?


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
move the sheet tabs [email protected] uk Excel Discussion (Misc queries) 1 December 27th 08 07:57 PM
move tabs [email protected] uk Excel Discussion (Misc queries) 1 December 27th 08 07:33 PM
Move list to different tabs Meredith Excel Discussion (Misc queries) 2 January 28th 08 09:25 PM
Can I move the tabs at the bottom to the top of the page? Jamie5284 Excel Discussion (Misc queries) 1 July 12th 07 04:00 PM
Excel 2002 : How to move to the next cell with content ? Mr. Low Excel Discussion (Misc queries) 2 February 2nd 07 03:41 PM


All times are GMT +1. The time now is 08:38 PM.

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

About Us

"It's about Microsoft Excel"