Advertisement

Sophisticated Selection of Cells in Excel 1.1      

Size:   240KB

License:   FREEWARE

Publisher:  Publisher | Listed Programs

Release Date:   2015-01-17

Submit Date:

OS:  Windows All

Downloads:   4665

Popularity:   Popularity:0/10


USER RATING

5.00

(3 Votes)

Write A Review

FreewareFiles Clean Award

Software Product Description

Advertisement
'Sophisticated Selection of Cells in Excel' is a handy utility for Microsoft Excel, which will help you select the cells in your spreadsheet using different types of criteria. Although the Excel program itself comes with a way of searching for and selecting cells, it has limited search options. Some users find it challenging to enter the required search criteria in the first place, and the selection results do not often reflect the actual data on the sheet.

The simple but powerful Excel utility allows you to use different criteria, including size, border, padding, font, text, alignment and cell protection. The application's different setting criteria are easy to understand even for users with basic knowledge of Excel. It uses Visual Basic for Applications technology, which makes it easy to automate tasks through the use of macros.

You need to run the XLSM file as well as the file or files that you want to make searches in. You will select cells in the files by entering the reference cell and the area where you want to search. Please note that you must enter the reference cell that the utility will use to search for relevant cells within the required area.

You may define the reference cell in a few simple steps. You can enter the workbook and worksheet cells or worksheet where you're the reference cell is found. You then need to mark the selected cell before pressing Ctrl+E on the keyboard.

You also need to enter the area where you want to make your search on the workbook or worksheet. You may select a worksheet, workbook or a defined area marked by an upper left cell and a lower right one. Once you have marked the required area, press Ctrl+R.

You can freely adjust each criterion. The reference cell and area to be searched do not necessarily have to be in the same worksheet or workbook. After defining the reference cell and search area, you can initiate the search process by clicking the 'Start' button.

'Sophisticated selection of cells in Excel' is a portable application that does not require installation. The utility is available in English and Slovak.

System Requirements:

  • Windows XP or later operating system
  • At least Microsoft Office 2007
Advertisement