ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   what is meaning of insurt menu name option (https://www.excelbanter.com/excel-discussion-misc-queries/194665-what-meaning-insurt-menu-name-option.html)

uthpala

what is meaning of insurt menu name option
 
I want to know what is meaning of insurt menu name option.
How to create name,past,create,apply and label

Bernard Liengme

what is meaning of insurt menu name option
 
Let's say cell K1 has your state sales tax, say 7%
So in a formula you might have =A10*K1 to compute the tax on an item

If you give K1 the name of "tax", you can use =A10*tax
After giving the call the name you can edit the cell with =A10*K1 and use
apply to have it change to =A1*tax
Paste just pastes then name

Now would be a good time to get an Excel book and read more
Notwithstanding the Web, books are not obsolete yet
Or you could Google for "excel name"
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"uthpala" wrote in message
...
I want to know what is meaning of insurt menu name option.
How to create name,past,create,apply and label





All times are GMT +1. The time now is 05:53 AM.

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