Skip to content
QuickExcel
  • Home

All About MS Excel Tips and Tricks

[Simplified] How to Rotate Text in Excel (2021)

In this article, we’ll learn to rotate text in Excel. Text rotation can be used when some numerical data are too long to fit in to the table column. The rotate tool simply rotates your texts the way you want it to make it look systematic. Steps to Rotate Text in Excel To learn to …

[Simplified] How to Rotate Text in Excel (2021) Read More »

How to Indent Text in Excel [Step-by-Step]

Let’s learn to indent text in Excel. Unadjusted or non-indented texts can be embarrassing and make your reports look unsightly despite your data being highly authoritative and useful. Learning how to indent or wrap a text is important if you want to submit presentable reports. Steps to Indent text in Excel Here is an example …

How to Indent Text in Excel [Step-by-Step] Read More »

[Step-by-Step] How to Add Borders in Excel (2021)

Want to add borders in Excel to clearly display specific data tables? Borders play an important role in tabular data representation. It helps classify headings and contents of a table for better interpretation of information.   Adding or removing borders in Excel is simple and easy. This article is a complete guide to adding borders to any …

[Step-by-Step] How to Add Borders in Excel (2021) Read More »

2 Methods to Separate First Name and Last Name in Excel

Splitting full names is a simple task and it takes less a minute to separate first name and last name from a cell. You may need to manage certain types of data where names of people must be separated into separate adjacent cells. Steps to separate the first name, middle name, and last name Let’s …

2 Methods to Separate First Name and Last Name in Excel Read More »

[Ultimate Guide] Using Goal Seek in Excel (With Examples)

The Goal Seek tool can be used to determine an unknown numerical figure to seek a particular goal number. Microsoft Excel can be used for analyzing highly utilitarian metrics like demand and sales forecasting, predicting, mathematical calculations, and more. Steps to use Goal Seek in Excel Let’s get started with this ultimate step-by-step guide to …

[Ultimate Guide] Using Goal Seek in Excel (With Examples) Read More »

How to stop Excel from rounding numbers?

In this article, we’ll learn how to stop Excel from rounding numbers. When you enter a number in a cell, Excel may round it off. It is quite annoying when Excel keeps rounding off numbers. While there may be several reasons behind this but the most common reasons are: If the cell width is small, …

How to stop Excel from rounding numbers? Read More »

How to insert today’s date in Excel?

In this article, we’ll learn how to insert today’s date in Excel. Many a time, we need to insert today’s date in a worksheet. There are two types of date insertion available in Excel: static and dynamic. Both are suited for different purposes. We’ll see the two types in action in the following sections. Recommended …

How to insert today’s date in Excel? Read More »

How to delete a sheet in Excel [Simplified steps]

If you have added extra sheets by mistake or any other reason then do not worry because it is very easy to remove or delete a sheet in excel. Locating current sheet If you want to know the name of the current sheet you are working on in Excel, then simple run your eyes down …

How to delete a sheet in Excel [Simplified steps] Read More »

Create a Pivot Table in Excel – The Complete Beginners Guide

A Pivot Table is a magical data analysis tool that will help you handle these extremely large data sets effortlessly and in the shortest time possible. With Pivot tables you can easily manage, re-order, categorize and classify large databases into fewer relevant data sets. Steps to create a pivot table from scratch Let us proceed …

Create a Pivot Table in Excel – The Complete Beginners Guide Read More »

Posts navigation
← Previous Page 1 … 27 28

Recent Posts

  • How to Normalise Data in MS Excel?
  • How to Add Serial Numbers in MS Excel?
  • How to Delete Multiple Rows in MS Excel?
  • How to Convert Txt file to Excel file?
  • How to Count Unique Values in MS Excel?
Copyright © 2022 QuickExcel
About Us - Privacy Policy - Contact Us