Cell reference between worksheets

  • Thread starter Thread starter jitu_tikili
  • Start date Start date
J

jitu_tikili

While trying to link F5 of Sheet2
using = and selecting F5 of Sheet1,
THE CELL IN SHEET2 SHOWS =SHEET1!F5,
instead of the value of F5 in Sheet1.

The cell in sheet is formatted(Border, colour, merged & centred cell).

However I am able to link other cells of the worksheet to various othe
cells in other worksheets.

Please guide.

Jit
 
....make sure you didn't inadvertently put an apostrohpe (') before the formula.
 
You must log in or register to reply here.

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

how do I create a nonadjacent series for autofill to go by? 3
HyperLinkDumbIam 2
reference work sheet name by using a formula 3
HYPERLINK() Help 1
How to conditionally reference a cell 3
data from 1 sheet to the next 6
Can I keep linked cells between sheets when using tables? 2
Randbetween Range Problem 0

Back
Top