How many rows and columns does Excel have now and in the last 25 years of Excel for Windows and Mac? All the talk about 64-bit versions of Office has raised the issue of maximum rows and columns in Excel. A few readers seem to believe that 64-bit Excel will
Excel has six different choices for removing content, formatting, comments or everything from cells. Five are on the ribbon plus another hidden away. Plus three useful keyboard shortcuts, one obvious and two very obscure. Home | Clear On the right of the Home tab is a selection of five ‘Clear’
What can you do with a file attachment that has no file extension? Sometimes you get a file, probably an email attachment, that has no file extension. Without something after the dot/period (.doc .docx .xlsx .pptx etc.) Windows doesn’t know what program to use. This is most likely to happen
Modern Excel has a danger zone that hackers increasingly use to get into your computer. It’s been there for well over twenty years but is being abused a lot more in 2021. Here’s how to disable it. The problem is in a very old method of Excel automation called Excel
Type the Tau – lower case τ letter into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. Tau (lowercase τ) is the 19th letter of the Greek alphabet. The lowercase letter is used in Biology, Mathematics and Physics, such as proper time in relativity. In ancient times it was also used as
Type Zeta – lower case ζ into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. Zeta – lower case ζ symbol is the 6th letter of the Greek alphabet. It is used for various mathematically and scientific reasons, such as representing the Riemann zeta function, the heat flux through a
Type Gamma upper case Γ and Gamma lower case γ symbols in Microsoft Word, Excel, PowerPoint, or Outlook. Both in Office for Windows and Office for Mac. Gamma (uppercase Γ / lowercase γ) is the third letter of the Greek alphabet. It represents the “g” sound in Modern and Ancient Greek.
Word’s Advanced Find has many special codes to help locate or replace hidden or unusual things in a Word document. Here’s a complete and searchable list of all the ^ codes and what they are for Under Find | Advanced Find | More | Special there’s a list of special
Type the Sampi Ϡ letter into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. Sampi Ϡ symbol is occasionally used in Greek today. Its modern form, which resembles a slanting right cross-stroke with a longish curve, evolved during its use as a numeric symbol in Byzantine minuscule handwriting. Informally, its often replaced by lowercase
Theta upper case Θ, Theta small upper case θ and Theta lower case ϑ symbols in Microsoft Word, Excel, PowerPoint, or Outlook. Both in Office for Windows and Office for Mac. Theta (uppercase Θ or θ / lowercase ϑ) is the eighth letter of the Greek alphabet. The lowercase symbol represents many things, such as an unknown variable in trigonometry, or
Type the Koppa upper case Ϟ and Koppa lower case ϟ symbols in Microsoft Word, Excel, PowerPoint, or Outlook. Both in Office for Windows and Office for Mac. Koppa (uppercase Ϟ / lowercase ϟ) is a letter used in the earlier forms of the Greek alphabet, it was originally used to
The wildcard is an advanced finding feature that has some powerful options beyond the standard * and ? options for Word. What Word calls ‘wildcard’ is really Regular Expressions, or at least a version of RegEx. Beginning or end of a word The beginning of a word can be represented
Microsoft Word seems to have two pairs of shortcuts that do the same thing – increase or decrease the font size. This is how they are different. The shortcuts are: Ctrl + Shift + < or Ctrl + Shift + > – which are also buttons on the Home tab.
We place all of the “Shortcut of the Week” tips from 2004 in the one convenient place. Tip 1 – Undo The Undo function has become especially important over the years as Microsoft puts more ‘intelligence’ into their products. Sometimes it ‘corrects’ your spelling or re-formats something you were quite
Excel isn’t just for budgets and number crunching, you can use it for making lists and even organizing your love life! Lisa used Excel to find her True Love. She listed all her dates in Excel with details somewhat like this… Excel, combined with some personal rules. eventually led her
How to type the ‘Numero’ symbol and other special characters – there’s many ways to do it in Word and Office. It all started with a single, seemingly simple, question from a reader. As often happens, the question opens up a whole range of options in Office Entering the Numero sign
How to get a ‘Chalkboard’ or ‘Whiteboard’ effect in Microsoft Word. Recently we talked about Text Boxes in Word and how to get various looks for sidebars and columns. How about copying the ‘chalkboard’ or ‘Whiteboard’ effect for a different style of text box not offered by Microsoft in their
How to sort a list using a hidden or unseen column in a Microsoft Word table. Sometimes you want to sort a list in a way that isn’t apparent to the reader. To continue our Apollo theme, here’s a list of the twelve men who walked on the moon with
You can hide a table column in Word, all it takes is a little trickery and ignoring Microsoft’s advice! Sometimes you want to hide a table column in a Word document but according to Microsoft you can’t do it. Here’s how to do it anyway. It’s true that there’s no
We’ve all seen the standard Find/Replace in Microsoft Word, either the ‘new’ pane or the older dialog box. Like so much else in Word, there’s a lot more available than the obvious features. Here’s a look at some of tricks. Press Ctrl + F to start a Find. In recent
Microsoft Word’s Replace does a lot more than just replacing one bit of text for another. It can quickly change formatting, enforce a style, paste from clipboard and use special characters. You’re probably familiar with the basics. Press Ctrl + H to open the Replace dialog. Type in the text
Hyphenating words in Word has many choices; manual, optional, compulsory (non-breaking) and fully automatic. Manual Hyphen The simple one we all know. Type the – on the keyboard (properly known as the Hypen-Minus) to hyphenate a word, e.g. choreo-animator. See Of hyphens, em-dash, en-dash and more Automatic hyphenation Word will
How to insert the Psi upper case Ψ, and Psi lower case ψ symbols in Microsoft Word, Excel, PowerPoint, or Outlook. Both in Office for Windows and Office for Mac. Psi (uppercase Ψ / lowercase ψ) is the 23rd letter of the Greek alphabet. The symbols are commonly used within physics to
About the RAND() function to make random numbers in Excel plus related functions RandBetween() and RandArray() plus some tricks for getting whole numbers only and even rolling ‘dice’ made in Excel. By Michael Barden Typing the =rand() function into a cell in an Excel spreadsheet will return a random number
