Microsoft 365 Blog
Recent articles
Two tips for faster worksheet navigation
<p>If your workbook contains a ton of worksheets, it can be a hassle to navigate to just the right sheet. For one thing, you often can't see all the sheet names at the bottom of the workbook. Sure, you can move around by using the four navigation buttons to the left of the worksheet tabs, or by pressing Ctrl + Page Up or Ctrl + Page Down, but there are faster ways to jump from sheet to sheet. </p>Celebrate a Decade of Windows XP by Moving to Windows 7
Shortly after the world entered the 21st century, we launched Windows XP. Now in just two weeks we’ll celebrate its 10-year anniversary. A decade ago the majority of the PCs shipped were desktops and today they’re laptops. In fact, IDC has interesting stats that puts this into perspective. In 2001, about 80% of shipments worldwideUse cross-references to link to other parts of a document
<p>You've heard that cross-references can enhance the professional quality of a research paper. What are cross-references and how do they work? A cross-reference is a pointer or link to an item that is in another location in a document - for example, "See Figure 1" to link to a salient graphic. You can create cross-references to headings, footnotes, bookmarks, captions, and numbered paragraphs. </p>Speed up data-entry tasks by using End Mode
<p>The other day, I was filling out a huge Excel table, and I found myself needing to enter the exact same information in multiple cells. To save time, I used something called End mode in combination with the arrow keys on my keyboard to quickly select all the cells I needed to change. Many of my own coworkers have never heard of End mode, so I thought you might not know about it either. It's a handy status bar option, and in my opinion it's often easier to use than fill down when you need to update a lot of cells at once. </p>Line or scatter chart?
<p>Ah, the great questions of life: Paper or plastic? Line chart or scatter chart? Choosing the wrong chart type for your data can easily happen when it comes to line and scatter charts. They look very similar, especially when a scatter chart is displayed with connecting lines, but there is a big difference in the way each of these chart types plots data along the horizontal and vertical axes. Let Excel writer Frederique be your guide as to which type of chart to use and when.</p>Making sense of dollar signs in Excel
<p>We've noticed some of you searching for help using "$" — a dollar sign. In Excel, a dollar sign can denote a currency format, but it has another common use: indicating absolute cell references in formulas. In this post, we'll talk a bit about both uses of the dollar sign.</p>Livescribe smartpen users can now easily connect to OneNote
<p>Smartpens are wonderful devices that can record everything you handwrite (and everything you hear, such as in a lecture). Livescribe smartpen users can now send pencasts of their notes and audio recordings directly into OneNote, where such content becomes fully searchable, thanks to OneNote's fantastic ability to search for text in handwriting, images, and even audio recordings. Read the full blog post to learn where you can download the new version of Livescribe Connect that now adds full OneNote support!</p>![Smiling woman sitting behind a Microsoft-branded computer.](https://www.microsoft.com/en-us/microsoft-365/blog/wp-content/uploads/sites/2/2022/05/MSC22_PICHA_office_119453-300x200.jpg)