How to Insert Page Breaks in Excel (for Perfect Printing) Remember those dotted blue lines and watermarks like Page 1, Page 2, etc. all around your spreadsheet? Those are page breaks inserted by Excel. A page break is a separator that divides the worksheets into different portions for printing 📸 It defines the [...]
Add Secondary Axis in Excel: Two Y Axis Chart A chart with an x-axis and a y-axis is fine. But how cool would a chart with three axes 3️⃣ The third axis here will be the secondary y-axis (that comes to the right side of the chart). It helps analyze the data plotted [...]
How to Hide Filter Buttons in Excel in 1 minute While working on a large data set in Excel, you add filter arrows to easily filter data. To maintain your data set and make it more understandable for other Excel users, you may want to hide AutoFilter arrows. It's super quick and easy [...]
How to Extend a Trendline in Excel: Step-by-Step A trendline draws a general trend out of any given dataset. This helps with trend analysis and data analysis. And why only the general trend of the dataset? Using trendline extensions, you can also forecast the behavior of a dataset in the future. Extending trendlines [...]
How to Center a Worksheet Horizontally in Excel It is not as simple to print an Excel sheet as it is to print a Word document. Most of the time, when you print Excel sheets, the data is not properly aligned on the page. Your dedicated work appears unprofessional as a result 😩 [...]
Create a Sankey Diagram in Excel: Step-by-Step A Sankey diagram, also known as a Sankey chart, is a lovely flow diagram 😊 It shows the overview of the flow characteristics of complex processes visually. Fun fact: 💡 This was introduced by an Irish engineer named Matthew Sankey to illustrate the energy efficiency of [...]
How to Create an Area Chart in Excel An area chart mimics the idea of a line chart. The only difference between a line and an area chart is the shading between the lines of an area chart. An area chart shades the area covered by a dataset to show its volume. That’s [...]
How to Turn Excel's Dark Mode On/Off (Menus and Cells)It's time to change the look and feel of your Microsoft Excel default theme!Microsoft now includes a dark mode option in its Office suite. Dark mode flips the color palette so that the interface is dark. This makes the screen more comfortable to read and [...]
How to Remove Table Formatting in Excel - Without Losing Data You’d know about Excel tables and the great functionalities that they add to your Excel 💪 From a clean, pre-defined format to sorting and filtering of data – Excel tables will never fail to amaze you. However, sometimes you might not want [...]
How to Insert a Slicer in Excel Pivot Table We occasionally filter data when building Pivot tables. However, the user may not easily understand what is specifically filtered if the data is filtered using the report filter option 😵 The best Excel solution for this issue is to insert slicers. Slicers are visual [...]