The Quick Find Next (Repeat Search without Dialogue Box) – Excel Tip

 

In order to search a text in an Excel File  we need to invoke the “Find and Replace” tool in Microsoft Excel by hitting [Ctrl]+[F] as shown in figure 1.1 below…

Figure 1.1

To search the next occurrence of the text one has to again invoke the same “Find and Replace” dialogue box.

However, not many of us really know that Excel provides a quick way to repeat the search without invoking the Find dialogue. The quick Find Next works as stepped out below…

1. Invoke the “Find and Replace” dialogue box by pressing [Ctrl]+[F] key combination
2. Type the text that you intend to search and click “Find Next” button in “Find and Replace” dialogue box.
3. Press [Esc] key to close the “Find and Replace” dialogue box.
4. Press [Shift] + [F4] key combination to repeat the search without invoking “Find and Replace” dialogue.

I hope you found the tip useful and thank you for reading.

Did You Know ? You could Quickly Delete several Blank Rows in Excel

Guys if you have a huge worksheet with several blank rows, what do you do? The answer is simple.. Delete Them so that data is organized and can be used more meaningfully.

Question now is how do you delete all such blank row in single go? Do you write a macro? or Do you select each row manually and delete them? But what if the blank rows are in hundreds?

There is one simple and quick way to handling such spread sheets. Guess what? The best way to handle such scenario is to sort your data. Depending on your sort criteria the blank rows would either appear on top or at bottom. If they are at bottom you simply have no issues otherwise you could simply delete the blank rows.

But there could be an issue. What if you wanted all your data to be restored back in original order post deleting blank rows. There is a solutions to this. Below steps would be helpful…

1. Insert a column before the first column in data or use column next to the last column.
2. Enter numbers in the ascending order in first cell and drag it down till the last row containing data.
3. Sort the data on column other than the one you inserted in step 1.
4. Delete blank Rows in bulk
5. Sort the data back on column you inserted in step 1 above.

Microsoft Office 2010 in Beta State

 

For all office lovers, users and those who hate as well there is a news about the new version of Microsoft Office. Yes you heard it right. Though many of us do have developed the comfort with the Office 2007 Microsoft is about to release Office 2010.

But not to worry. Microsoft Office is in Beta State as of now and is available for download in case you wish to evaluate and contribute to the features of the Microsoft Office. The download is available in two flavors as listed below…

1. Microsoft Office 2010 Developers download
2. Microsoft Office 2010 IT Professionals download

Needless to describe which download is intended for which audience. For Microsoft lovers this is certainly a good news. And for all those anti-Microsoft the new opportunity to find holes and vulnerability in the new program.

To grab a beta testing copy of Microsoft Office 2010 please visit www.microsoft.com or Click here.

I hope you found the information useful and Thank you for reading.

Making your Excel 2007 files backward compatible

 

While working with Excel 2007 several users have been inadvertently creating files that are not compatible with the older version of MS Excel e.g. 2003, 97 etc. One way to ensure that you workbook is compatible with the older version you need to Save your workbook in appropriate Excel format that recipient of the file is expected to have or use the compatibility checker tool on your workbook so that you can fix potential issues.

To ensure that a MS Office Excel 2007 workbook does not have compatibility issues that may cause loss of some or several functionality in an earlier version of Excel, you must run the Compatibility Checker tool unless you are already working on a file created in earlier version of MS Excel. The Compatibility Checker tool discovers any potential compatibility issues and can create a report for you. Follow the below instructions to use Excel 2007’s Compatibility Checker tool…

• In Office Excel 2007, open the workbook that you want to check for compatibility.
• Click Microsoft Office Button ( )
• Click Prepare
• Click Run Compatibility Checker.
• To ensure the Compatibility is checked for every time you save the workbook, select the Check compatibility when saving this workbook check box.
• To create a report in a separate worksheet of all the issues that are listed in the Summary box, click Copy to New Sheet.
• Clicking Fix button may resolve some simple compatibility issues.

I hope you found the information useful and Thank you for reading.