Home |
Search |
Today's Posts |
#1
|
|||
|
|||
bold italics or underline
I am using 4 sheets in Excel (meaning the tabs on bottom of screen) and I
need to carry over the words or phrases that are in Bold , Italics or Underline. How do I carry over to each sheet the text in bold, italics or underlined words? Because I have to go to each individual sheet and change the words I need to be in bold italics or underline. |
#2
|
|||
|
|||
What exactly do you mean by "carry over"?
If you simply "Copy" & "Paste", the data is duplicated *together* with the formats. -- HTH, RD ============================================== Please keep all correspondence within the Group, so all may benefit! ============================================== "Dorothy" <Dorothy @discussions.microsoft.com wrote in message ... I am using 4 sheets in Excel (meaning the tabs on bottom of screen) and I need to carry over the words or phrases that are in Bold , Italics or Underline. How do I carry over to each sheet the text in bold, italics or underlined words? Because I have to go to each individual sheet and change the words I need to be in bold italics or underline. |
#3
|
|||
|
|||
Let me give an example :
I am using 4 sheets - meaning the tabs on the bottom In cell A1 I type in the word "Excel" in BOLD print I want that word to also show up on all four sheets in BOLD How do I do that ? Thanks for your help "Dorothy" wrote: I am using 4 sheets in Excel (meaning the tabs on bottom of screen) and I need to carry over the words or phrases that are in Bold , Italics or Underline. How do I carry over to each sheet the text in bold, italics or underlined words? Because I have to go to each individual sheet and change the words I need to be in bold italics or underline. |
#4
|
|||
|
|||
Select all sheets (click first, hold down shift and click the last), click
in A1, type and format bold, ungroup the sheets Otherwise you'd need VBA since if you link everything to sheet 1 the format will not come over -- Regards, Peo Sjoblom "Dorothy" wrote in message ... Let me give an example : I am using 4 sheets - meaning the tabs on the bottom In cell A1 I type in the word "Excel" in BOLD print I want that word to also show up on all four sheets in BOLD How do I do that ? Thanks for your help "Dorothy" wrote: I am using 4 sheets in Excel (meaning the tabs on bottom of screen) and I need to carry over the words or phrases that are in Bold , Italics or Underline. How do I carry over to each sheet the text in bold, italics or underlined words? Because I have to go to each individual sheet and change the words I need to be in bold italics or underline. |
#5
|
|||
|
|||
If that "Excel" is going into the *same* cell on all 4 sheets, *before* you
start typing, *Group* your sheets together, then type and format, where whatever you do to one sheet is duplicated on *all* the other grouped sheets, then ungroup. If the "Excel" is to be duplicated in different cells, "Copy" the cell from the first sheet, and navigate to the particular cell on each of the other sheets, where you'd right click in each cell and choose "Paste". HTH, RD ============================================== Please keep all correspondence within the Group, so all may benefit! ============================================== "Dorothy" wrote in message ... Let me give an example : I am using 4 sheets - meaning the tabs on the bottom In cell A1 I type in the word "Excel" in BOLD print I want that word to also show up on all four sheets in BOLD How do I do that ? Thanks for your help "Dorothy" wrote: I am using 4 sheets in Excel (meaning the tabs on bottom of screen) and I need to carry over the words or phrases that are in Bold , Italics or Underline. How do I carry over to each sheet the text in bold, italics or underlined words? Because I have to go to each individual sheet and change the words I need to be in bold italics or underline. |
#6
|
|||
|
|||
Thank - You very much , Peo
You have no Idea how much that helps me :) "Peo Sjoblom" wrote: Select all sheets (click first, hold down shift and click the last), click in A1, type and format bold, ungroup the sheets Otherwise you'd need VBA since if you link everything to sheet 1 the format will not come over -- Regards, Peo Sjoblom "Dorothy" wrote in message ... Let me give an example : I am using 4 sheets - meaning the tabs on the bottom In cell A1 I type in the word "Excel" in BOLD print I want that word to also show up on all four sheets in BOLD How do I do that ? Thanks for your help "Dorothy" wrote: I am using 4 sheets in Excel (meaning the tabs on bottom of screen) and I need to carry over the words or phrases that are in Bold , Italics or Underline. How do I carry over to each sheet the text in bold, italics or underlined words? Because I have to go to each individual sheet and change the words I need to be in bold italics or underline. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
If cell is Bold then 1, if cell is Italics then 2? | Excel Discussion (Misc queries) | |||
Excel subtotals, add a sort option, and BOLD the function answers | New Users to Excel | |||
Help to edit (bold, colour etc) words in a text box created by control toolbox | Excel Discussion (Misc queries) | |||
How do I underline? | Excel Worksheet Functions | |||
If cell is Bold then 1, if cell is Italics then 2? | Excel Discussion (Misc queries) |