Benefits of Naming Cells in Excel
video description
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.
Date: 2022-04-08
Related videos
Comments and reviews: 9
Joe
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.
reply
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.
reply
Medo
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.
reply
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.
reply
Suzanne
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!
reply
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!
reply
technology_for
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
reply
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
reply
The
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.
reply
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.
reply
Rajeev
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'.
reply
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'.
reply
Mcgregor
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
reply
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
reply
Joseph
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?
reply
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?
reply
Barry
Excellent video you are a great teacher. Speed is spot on and the explanations of each point is so easy to follow. Thank you.
reply
Excellent video you are a great teacher. Speed is spot on and the explanations of each point is so easy to follow. Thank you.
reply
Add a review, comment
Other channel videos
