Finding external links
Posted by Shikha on July 15th, 2008This article shows how to locate cells in active workbook which contain links to external workbooks.
Share ThisPopularity: 10%
This article shows how to locate cells in active workbook which contain links to external workbooks.
Share ThisPopularity: 10%
Sometimes we want to pull out data on one sheet from different worksheets, all of them having the same structure.We can do that using the vlookup or hlookup function as the case may be. However, while selecting the appropriate range we will have to go to each tab and select the range manually. This can be very time consuming especially if there are lots of tabs. Excel’s indirect function can help us get around this.
Share ThisPopularity: 13%
If we save some file without giving the path, then it will automatically get saved at the default location. We can change the Default File Location as:
1.Click on the Tools menu
2.Choose Options
3.Click on the General tab
4.Enter a new path in Default File Location and hit OK.
Popularity: 9%
This article explains how we can have A-Z letters on a column without typing them in manually.
Share ThisPopularity: 22%
This article explains how to deal with a situation when your keyboard gets locked without you even knowing it.
Share ThisPopularity: 17%
This article shows how to reach other tabs in a workbook quickly when you have lots of them. Apart from simple “CTRL+PageUP/Pagedown” option, it talks about other alternate solutions like “Excel’s activate sheet option” and “Insert hyperlink” which are less time consuming and more efficient ways to navigate comfortably between worksheets.
Share ThisPopularity: 16%
This article describes in detail why excel takes so long to open and how can you get around it.
Share ThisPopularity: 20%
This article shows how to generate a list of all the worksheet names on a worksheet.
Share ThisPopularity: 26%
This article introduces you to “Define Name” feature of excel with which you can give a name to any cell or range of cells and then just use that particular name in other formula’s like vlookup, offset, match etc without having to select it manually every time.
Share ThisPopularity: 15%
This article shows how to get the count using more than one criteria. Additionally, it talks about the “conditional formatting” feature which highlights the important results and spares you the inconvenience of having to look at everything in detail.
Share ThisPopularity: 28%
This article shows how to take screenshots in general and also gives special methods which are excel specific.
Share ThisPopularity: 24%
Did you ever wonder why can’t you find asterisk and question mark in your spreadsheet.This article explains it all.
Share ThisPopularity: 26%
This article gives you a quick and easy way to access applications like excel, word, notepad, mspaint, internet explorer etc. In addition, it shows how to display “Run” tab on the start menu.
Share ThisPopularity: 20%
Did you ever have problems sending excel files of several MBs through your email systems?? Sometimes it rejects it because it exceeds the quota size or takes forever to send…….This article shows how to split huge excel files into smaller parts which can easily be sent.Plus, it explains how to put them back together.
Share ThisPopularity: 16%
This article is about how to access your recent documents. Most of you would be familiar with the “My Recent Documents” option on the “Start” Menu but this just shows 15 recently visited files….Which is clearly not enough so in this article we have given alternate options which are more comprehensive.
Share ThisPopularity: 32%
This article shows how to make a list of the folders, or even the files inside a folder on an excel spreadsheet.This is a very useful tool as it is impossible to type in the names manually especially when there are plenty of files.
Share ThisPopularity: 41%
At first sight, this article may look long-winded to you, but trust me, with a little concentration and patience, this article alone can help you master all the difficult excel functions like offset, indirect, index, match etc. So, if you are ready to take the plunge, here is the magic article.
Share ThisPopularity: 88%
This article shows the magic of Shift and Control keys and how we can use them with arrow keys to work faster.
Share ThisPopularity: 21%
This article is a basic guideline on how to insert excel spreadsheet into word document. It gives a comprehensive list of the available options and describes each one of them in graphic detail.
Share ThisPopularity: 100%