Friday, March 12, 2010

Opening A Link Workbook

So many times we use another workbook data as a reference data by linking files to open those link or source files from the main file we could use following method

Go to Edit Menu open link and click on Open source

Or We can use Shortcut Key for this that is Ctrl+[

Regards
Hemant
at

1 comment:

  1. Michael LengAugust 10, 2018 at 2:34 PM

    That's a very interesting article. It helps to save time and operate it with more ease. Thank you so much for your useful article.

    Ctrl + ' (apostrophe) To Fill Cell Formulas Down From The Adjacent Cell Above

    ReplyDelete

Subscribe to: Post Comments (Atom)

Hi Friends, After a long break, I again started to work on this blog with new time-saving techniques and tricks for making the day to day...

  • Multiple Row Filters in Same Sheet
    I was working on my data sheet and countered with one problem I required filters in two row ranges on being specific I want the first fil...
  • Tips to look more profession in Excel
    Excel provides several underline formats to give your spreadsheets a professional look and to make them easier to read at a glance. For exam...
  • Web Page from MS Excel
    If you need to analyze data from a Web site, you might be in for a bunch of tedious retyping. Under the right circumstances, however, Excel ...