ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   How can i give name to the selection (https://www.excelbanter.com/excel-worksheet-functions/227005-how-can-i-give-name-selection.html)

manish

How can i give name to the selection
 
hi

Can u pls tell me how can i give name to a particular selection. which i
can use as a data selection for any required command.
--
MIS EXECUTIVE
RKHS

Rick Rothstein

How can i give name to the selection
 
Type the name into the Name Box (the unnamed field to the left of the
Formula Bar), then hit the Enter key. By the way, you can't have spaces in
the name.

--
Rick (MVP - Excel)


"MANISH" wrote in message
...
hi

Can u pls tell me how can i give name to a particular selection. which i
can use as a data selection for any required command.
--
MIS EXECUTIVE
RKHS



Jacob Skaria

How can i give name to the selection
 
Select the range and type in the name to the name box..(Left to the formula
bar)
After that Check the name in Insert|Name|Define


If this post helps click Yes
---------------
Jacob Skaria


"MANISH" wrote:

hi

Can u pls tell me how can i give name to a particular selection. which i
can use as a data selection for any required command.
--
MIS EXECUTIVE
RKHS



All times are GMT +1. The time now is 02:33 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com