How to Copy and Paste in Excel - Step-By-Step Copy/pasting is something we have all known for ages now. But there's so much more to the dynamic copy-paste tool of Excel than simple copying/pasting of values. And the guide below will show you how resourceful the copy-and-paste tool of Excel can be. So [...]
How to Move Columns in Excel (6 Easy Methods) Knowing how to move columns in Excel is as important as knowing how to copy and paste - it's essential. This is something you'd have to do almost all the time while you work in Excel. So what are you waiting for? Dive [...]
How to Separate Names in Excel (Split First and Last) Full names are usually typed into one cell. When using options like sorting, and filtering, it is important to separate full names into first, middle, and last names💡 Excel offers numerous ways to separate names🤔 Using a few examples, we will learn four basic techniques [...]
Microsoft Excel Viewer: How to Download, Install, and Use Never heard of Microsoft Excel Viewer before? Not a problem - this guide will take you through everything you need to know about it. As the name suggests, Excel viewer is an application that helps you launch and view (.xlsx) Excel format files. What [...]
How to Merge Cells in Excel (Without Losing Data) You can't split a cell in Excel but you can combine or merge cells in your worksheet. Merging combines two or more cells to create a new large cell. This is great for creating headlines or labels that span multiple columns or rows in [...]
How to Insert Multiple Rows in Excel (and Single Rows too!) Inserting rows in your worksheet is one of the most basic and repetitive things you do in Excel. Need to insert a blank row? Sure! That's easy! But what if you need to add tens or hundreds of rows to your worksheet? [...]
Excel Comments and Notes: How to Add, Edit, and Delete Excel comments and notes are very useful in adding information to a cell without changing the data itself or the format of the worksheet✍️ Amazingly, we can use Comments and Notes on a whole new level with the recent Microsoft Excel updates🙌 Now, [...]
How to Fix Arrow Keys Not Moving Cells in Excel (Scroll Lock) We are talking about the times when out of a sudden, your Excel sheet starts behaving weirdly. As you press the arrow keys, you are not navigated to the cells up or down, right or left. Instead, your Excel sheet starts [...]
The Best 11 Excel Shortcuts You'll Ever Need (With Examples) They say, "Time is money" and who doesn't want to save on money? 😃 If you are short on time too, then this article is for you. Microsoft Excel offers plenty of keyboard shortcuts to help users work swiftly and efficiently. All you [...]
How to Calculate Percent in Excel (Percentage Formula) We use percentages almost everywhere. For example, there's a 50% off this weekend, monthly sales have risen by 30%, you get an annual increment of 15%, etc. The percentage is a genius concept, and the best part – they are super easy to calculate. [...]