If you work with large Excel workbooks that contain multiple tables, it can become very tedious moving from one to the other. This is a quick and easy way to do just that and I think you will love it.
Follow the steps below to learn how:
Told you that you’d love it!
Can you believe it is November??? Well you better believe it. How could you not? I mean the television is showing Christmas and holiday advertisements and I heard Christmas Carols on the radio today!!! Could we please just have Thanksgiving first??
We have gone from temperate weather to frosts and freezing ! Holy cow! I do detest being cold even though I enjoy the change of seasons.
I hope you enjoy the articles this month as much as I enjoyed writing them for you. Please remember those less fortunate than yourselves during these cold months.
And please remember to let those you care for know that you do. You have no idea how this can change someone’s outlook. Smile at as many folks as you can too. It will make then smile back at you and then you will both fee good!
Until next time, take care of you!
Excel is very flexible in how it will allow you to set up custom formats for displaying all manner of values. Most custom formats are straightforward and easy to figure out, once you have an understanding of how custom formats work.
Suppose you wanted to create a two-line custom format, though? For example, you might want to format a date so that the abbreviated day of the week and day of the month is on the first line, and the full name of the month is on the second line. Using such a format, your date would appear as shown below.
Most of this can be done by the custom format ddd d mmmm, but you have to figure out a way to add a line break between the d and the mmmm. Excel will not let you press Alt+Enter between them, which is what you normally do to add a line break.
The solution is to use your numeric keypad to enter the desired line break in the format.
Follow the steps below to learn how:
After setting up the format in this way, you will need to adjust the row height of the formatted cells so that the entire two lines of the date will display.
Many of my subscribers lament the fact that WordPerfect used to have Block Protect wherein you would highlight a block of your text and protect it so that it would always appear on the same page.
Well guess what? You can do that in Word also! Is it that simple? Well I suppose you could say no, because Word actually has TWO different versions of Block Protect:
Follow the steps below to learn how to find and use these:
Click the little launcher at the edge of the Paragraph group on your Ribbon. This will open the Paragraph dialog box.
You can now select one or both of these options. What is the difference you might ask? See below.
Keep With Next will keep two or more lines of a single paragraph together (i.e., it will keep a block of text that does not have a hard return or a line break within the block all on one page).
Keep Lines Together will keep lines from separate paragraphs together on a single page (i.e., a heading and the first few lines of your paragraph). This is for a block of text that has one or more hard returns or line breaks or line breaks in the middle of it.
If you cannot decide which you need, you can always use both and it will still work for you. Just do not try to block protect very large blocks of text or you will run into problems.
