ExcelBanter - Locating text in spreadsheet

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Locating text in spreadsheet (https://www.excelbanter.com/excel-discussion-misc-queries/131451-locating-text-spreadsheet.html)

falcios

Locating text in spreadsheet

How can I locate text entered in cells.
I have a spreadsheet with many empty cells and I want to go to the next cell
that has data/text in it.
Thanks.

Renus

Locating text in spreadsheet

Hi,

Try Ctrl + Direction buttons.

Ctrl + flags to any side

"falcios" wrote:

How can I locate text entered in cells.
I have a spreadsheet with many empty cells and I want to go to the next cell
that has data/text in it.
Thanks.

All times are GMT +1. The time now is 09:50 PM.