There are several ways for an Excel table to be transposed (rows and columns) but none of the online suggestions work very well with tables. We’ve found a solution which transposes one table into a ‘swapped’ table i.e headers become column A and column A becomes the headers. Along the way we’ll explain a clever […]
Here’s an even better way to make an automatic list of tabs in an Excel workbook it works in Excel for Windows and Mac and bypasses some possible traps. Start with our article on Automatic worksheet/tabs list in Excel which explains how to add a list of Excel tabs/sheets with or without clickable links to […]
Here’s a complete list of the Word Function Key features from fast access to Help, jumping around the document, doc panes, spelling, grammar and managing field codes. Let’s discuss in detail the functionality of the F-keys labelled F1 through F12 on your keyboard. F1 – Help, field jump F2 – move, Print Preview F3 – […]
Insert the Epsilon upper case Ε, and Epsilon lower case ε symbols in Microsoft Word, Excel, PowerPoint, or Outlook. Both in Office for Windows and Office for Mac. Epsilon (uppercase Ε / lowercase ε) is the fifth letter of the Greek alphabet. The uppercase isn’t commonly used outside of the Greek language, due to the similarity to […]
The inverted or Spanish question mark ¿ is available in Microsoft Word, regardless of language setting. There’s even an in-built shortcut. ¿ is most commonly used in Spanish for the start of a question sentence. This guide is mostly for people without a Spanish keyboard or who only occasionally need the inverted question mark. See […]
