Benefits of Naming Cells in Excel
Вставка
- Опубліковано 25 сер 2024
- Learn how to name cells and ranges in Excel. You'll also learn some of the benefits that come from naming important cells and ranges. #exceltutorial ***Consider supporting Technology for Teachers and Students on Patreon***: / technologyforteachersa... Here's my entire playlist of Excel tutorials: bit.ly/tech4excel Here's a practice file that goes with the video: bit.ly/namingcells
I have seen all your videos and have learnt a lot Thank you so much for helping everyone. It is so clear the way you explain
This is the type of stuff that is saving my thesis right now
Easy to understand video tutorial. Thanks 🇬🇧
For years now I have just added an entire extra columns with repeating numbers to solve this issue. Thank you so much for this video
Your explanations are so clear and direct, not rushed and hard to follow. (The only thing I misunderstood is that F3 is only for *pasting* a named cell.) Amazing stuff, possibly the best on the web for this lifelong learner! Can't wait to watch more of them. Thank you!
But why 703?
Best teaching for Excel I've seen on UA-cam
Tons of great Excel tidbits in there. I love named cells/ranges because you don't have to modify formulas if you change the location of data - just modify the named cell info.
Amazing! Every time when I watch your video, I am amazed of how much valuable and useful information I have gained! I hated Excel before, and now I am looking forward to working in Excel
Excellent video you are a great teacher. Speed is spot on and the explanations of each point is so easy to follow. Thank you.
Helps me a lot. Thanks
Very simple explanation, clearly understood, thank you very much
Your videos have helped me doing a crash course in office 365 creating my yearly workbook of 10 separate sheets that link to summary page the column totals.
1.) do you know of a place we’re I could print most of the common keyboard commands and tape to bottom of screen while editing and creating pages. Like the command after clicking @sum and instead of scrolling up thru 640 col to be at top immediately like you explained in a prior video.
It Be similar to list of piano keys for different notes. The command key and many off the letters used make no common sense memory cues, much like many of the icons for a person like me that only uses the 27” 2019 IMac to do yearly taxes.
2.). I found different ways to print using different keys.
I had to create a table, download 2019 checkbook register, sorted them. Then listed Each item that could be used for medical expenses in separate columns across the top to put expenses in rows below for each category. I spent 6 hours trying to print it landscape, using the page number command, added top rows to repeat on each page , selected print are by col, row tried without and without page breaks and only way it print without tons of columns. On separate sheets together was by turning a 2 page sheet was turning it into a 18 page sheet.
I finally called free excel support and the techs windowed in and tried every thing I had done. I had even tried to no avail using printer software. The techs came to same solution I was going to do.
Take a screen capture and it printed all on one page, small text, but filled up the entire page. Luckily when I faxed it to folks requesting information it went thru clear enough to read.
Did Microsoft do away with the windows 7 Excel option of pulling up the page and using interactive margins and page separation.
The techs were as frustrated after a 2.5 hour phone call trying everything possible to get it to print larger which it had plenty of room to fit and allow the fonts to be larger.
Either we all missed something or the new excel printing options leave much work to be done to make it more user friendly when it takes longer to set up undesirable, but barely usable printing features.
Going to have to go thru and set up every page of the workbook to print a hard copy and it’s taking longer to get it to correctly print that it did to download and either import or copy and paste the data,
I appreciate any help you could give. The printing videos you have done hold no secrets I can find to make it simple.
I've been wondering how to fix this issue for a while. Thank you for what you do !!
you can use F4 for fixing the height cell instead of using name box
Thank you. ... I always wonder how to do that
Amazing naming trick.
Hi,
Got a suggestion, it would be great if you provide us with a project to do, and then after a period of time you could provide the answers for the project or the best of solving the project. For example, create a budget sheet and ensure the sum of the totals are updated automatically, or create a time sheet that once the date is entered (Ctrl + ;) other data in the cells are automatically entered.
Thank you for your well-presented videos, and just started to support in your Patreon account.
Incredible, thanks
Thanks for this tutorial, I learned a number of ways to use Excel that I wasn't aware of. It was very easy to understand.
Frankly, what I was looking for is whether or not it is possible to name the column (i.e, column A becomes "First Name", column B becomes "Last Name", etc.).
I have lists with thousands of business plus over 40 columns of info for each business in the list.
What I'd like to be able to do is scroll through the list and know what it is that I'm looking at.
If you know how to do this, I'd sure appreciate learning how do to it.
.
Mm
.
D
The practice file link doesn't seem to work--it brings me back to this vid page. Thank you.
Thank you
Hello, Is it possible to vlookup a formula. Example : I have a calculation sheet which has height and width. and cell for type of item. when i select the type i want the formula cell to vlookup the formula in another sheet corresponding to the type. like type plain is height+width, and type folded is height * 2 + width * 2
I’ve used cell naming for years but occasionally run into a problem that is inconvenient and confusing where named cell references do not update when a workbook is copied or saved to a new name! The cells seem to hold the old contents until I select the cell and hit enter. I haven’t been able to find a way to force excel to refresh all name cell references in the workbook.
Any ideas???
does this keep the formulas accurate if you need to move the cell, or does the name reference the now blank cell. i have a reference cell that i want to move to a more organized area of my spreadsheet, but i don't know if it'll ruin all the formula i put in
What is your Excel's version
its also not allowing me to make changes to my names, it's all greyed out
Hi, want to know how to sort a sheet by name of cells. Say I have some cells named 'X' and I want to see the sheet(both rows an volume) containing only cells named 'X'.
You might need to learn how to filter (Home tab > Editing group > Sort & Filter > Filter…)
Hi, nice tuto. One question! How can i do (time 04:50) to show me the same Ctrl+F3 on the mac? Christ bless u.
On a Mac, the fn key is in the very bottom-left corner of your keyboard.
@Suzanne Tourtillott Thanks for your information, so helpful. 😊
Hamza gull
Referencing i.e fixing the cell would be an appropriate alternative.
Perhaps it would have been better to have put this video before the fixing common errors part 1?
where does the 703 come into it?
703 i belive is part of a BMI formula used in calculations of BMI using pounds and inches .
So is just a number, nothing to distract.
I don't have and social media accounts
Thanks for your sharing. So I'm your slave