The Research pane is a small utility build in some Office applications. It allows to search the meaning of a word, get synonyms, pronunciation… The Research Pane is, however, often opened by accident. When pressing the ALT key and clicking, the window opens on the right side. This can be very annoying to say the Continue reading →
Excel
Excel: Center text across multiple cells without merging
To center text across multiple horizontal cells in Excel, a solution could be to merge the cells together and then center the text. However, this often makes it harder later on to copy and paste the cells to another Excel sheet. Instead, we’ll go to alignment settings to center text across cells. First, select the Continue reading →
Excel: COUNTIF: The formula you typed contains an error
In Microsoft Excel (part of the Microsoft Office productivity suite), you can count the number of times a string (a piece of text) appears in a range of cells. Let’s take the following table as an example: Option A Option B Option C Totals X X 2 X 1 X X X 3 To get Continue reading →