ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   excel table (https://www.excelbanter.com/new-users-excel/28913-excel-table.html)

lsy

excel table
 

how can i set the "name" and "range" in the "Excel table"??


--
lsy
------------------------------------------------------------------------
lsy's Profile: http://www.excelforum.com/member.php...o&userid=23917
View this thread: http://www.excelforum.com/showthread...hreadid=375910


CLR

If you are talking about creating a new table or range, highlight the area
you wish to make a range, then do Insert Name Define, and type the name
you wish to give the range in the small window at the top of the
pop-up.........the "Refers to:" window shows you what range is assigned that
name.

If you are talking about re-setting your "Print Area"...........then
highlight the area you wish to print, then do File Print Area Set Print
Area.

Vaya con Dios,
Chuck, CABGx3


"lsy" wrote in message
...

how can i set the "name" and "range" in the "Excel table"??


--
lsy
------------------------------------------------------------------------
lsy's Profile:

http://www.excelforum.com/member.php...o&userid=23917
View this thread: http://www.excelforum.com/showthread...hreadid=375910





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

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