excelintoexcel

We are here to learn much about excel, active cell, excel to pdf, copy and paste, clipboard, format painter, formulas, excel tutorial, transpose, border, row and column, paste special, cut paste, clip board, font size, font style, borders, fill, font color, format cell, number, protection, currency, accounting, date, time, percentage, fraction, scientific, custom, export, page setup, selection, hiding, sheet rename, align, orientation, wrap text, merge cells, conditional formatting

Saturday, November 16, 2019

Go to | last cell | visible cells only

Last Cell

Last cell denotes the cell that contains data and/or formatting.
Even one deletes the data and/or formatting of the cell, Last Cell function identifies that cell.


Last Cell

Procedure

Click any where in the sheet.
Press Ctrl+G and click 'Special..' or Click 'Find & Select' under Home Tab and click 'Go to Special...'.
Tick the Radio button associated with 'Last Cell' function.
Click Ok.

Visible Cells Only

'Visible Cells Only' function identifies those cells that are visible in a range. It helps to identify the filtered rows or columns when filters are enabled in a sheet.

Even it helps to identify any hidden row or column in the sheet.

It is useful.

Conditional Formats

'Conditional Formats' function identifies the cells with conditional format embedded.

Data Validation

Data validation function identifies cells with data validation embedded. Further sub categorized as 'All' and 'Same'.