How can I write a formula to automaticallycopy over text within an Excel spreadsheet?

M

mforhan

Version: 2008

I realize that this might be a terribly silly question but after two kids my brain is too fried to try to figure it out myself so I need help. I am on a Mac and I haven't used Excel for a few years. I am trying to create a Xmas budget spread sheet and I need help with getting the names to transfer over to a separate tab on the same excel spreadsheet. I cannot get any formula to work. Thankful for any and all help.
 
B

Bob Greenblatt

Version: 2008

I realize that this might be a terribly silly question but after two kids my
brain is too fried to try to figure it out myself so I need help. I am on a
Mac and I haven't used Excel for a few years. I am trying to create a Xmas
budget spread sheet and I need help with getting the names to transfer over to
a separate tab on the same excel spreadsheet. I cannot get any formula to
work. Thankful for any and all help.
Click to expand...
Very simple. On the destination worksheet, type an equal sign. Don't hit
enter, but switch to the tab containing the data you want, and then click in
the cell. Then press enter.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel for Mac 2011 function. 0
need help writing formulas. 1
Excel Mathematical formula 5
Cannot select and then copy an entire worksheet, in Excel 2008 8
How can I tell if a cell has a formula in it? 2
Importing into a pre-formatted spreadsheet 2
Function in Excel to count and list number of entries of text valuesin a row. 2
excel f function keys 1

Top