How To Reference Cells In Another Sheet - Web type an equal sign (=), switch to the other file, and then click the cell in that file you want to reference.
Web type an equal sign (=), switch to the other file, and then click the cell in that file you want to reference.