• Formulas
  • Excel Tips & Tricks
  • Excel Charting
  • Tutorials
  • VBA
  • Book Store
  • More
    • Blog
    • Download Area
    • Excel Video Tutorials
Home » Excel Tip Category

A Paste Special Trick To Convert A Number To A Percentage.

March 31, 2021 by Barbara —Leave a Comment

Hello, Excellers welcome back to another #Exceltips blog post in my 2021 series. Today let's look at using the Paste Special Function in Excel. Have you a worksheet with the % (percentage) formatting missing?.  If you ever have tried to correct this then you know you could try to adjust the formatting of the cell.  But, that just ends up looking like the screenshot below right?.   Who wants to edit each cell with %?. Well, by using Paste Special we can … [Read more...]

Filed Under: Blog, Excel Tip Category, Excel Tips& Tricks Tagged With: Excel, Excel Tips, excel tutorials

Quick Way To Remove Blanks -Excel Data Tidy Up.

March 17, 2021 by Barbara —Leave a Comment

Hello, Excellers. Welcome to another Excel Tips post in my 2021 series. In this blog post, I will share with you how to quickly remove blanks or spaces from your data set. This super quick method in Excel is great for data tidy up. The Paste Special function is used. So, let's get some data tidy up done. Here is a sample data set to use. Some blanks still remain from a previous data tidy up step. These probably have been left from a previous step in the process of data tidy … [Read more...]

Filed Under: Blog, Excel Tip Category Tagged With: Excel, Excel Tips, excel tutorials

Formula Friday – Applying Names To Your Existing Excel Formulas.

February 12, 2021 by Barbara

Hi Excellers, #formulafriday time again. Welcome back to another blog post in my 2021 series. Today is a bit different, I want to share with you how to rename or apply names to formulas that you may already have in your Excel worksheet. Let's take a look at an example. So, for example, you have inherited a worksheet that calculates the Sales Tax applicable to your monthly sales. Currently the value for Sales Tax sits in cell G1. Now, I like to use named ranges in my formulas, (if … [Read more...]

Filed Under: Blog, Excel Tip Category, Formula Friday, Formulas Tagged With: Excel Tips, Formula, formula friday, Formulas

Macro Mondays – Running An Excel Macro From The Immediate Window

February 8, 2021 by Barbara

Hello, Excellers welcome to another #MacroMonday #Excel blog post in my 2021  Excel Macro series.  Today let's take a look at using the Immediate Window in the Excel VBA debugging environment. This environment can be used as a type of scratchpad or sandbox area and has many uses as well as debugging code. You will need to first Enable The Developer Tab if it is not already enabled. You can watch my YouTube Video for instructions. https://youtu.be/CYcyoBMTZ44 If you … [Read more...]

Filed Under: Blog, Excel Tip Category, Excel Tips& Tricks, Macro Mondays, Macros, VBA Tagged With: Excel Tips, Macros, VBA

Drill Down Option In Excel Pivot Table.

January 21, 2021 by Barbara

Hello, Excellers. Welcome back to another #Excel Tip blog post. This Pivot Table blog will take you through the Drill Down feature in Excel Pivot Tables. When you create a Pivot Table in Excel, each of the values represents one line of data or record in that data set. The Pivot Table creates a summary of your data set. Let's use an example in this blog post. You can download the sample data set and Pivot Table, by clicking the download button below. I have a very simple data set and … [Read more...]

Filed Under: Blog, Excel Tip Category, Excel Tips& Tricks, Pivot Tables Tagged With: Excel Tips, Excel Tips& Tricks, Pivot Table

  • 1
  • 2
  • 3
  • …
  • 10
  • Next Page »

Tags

Blog Cells Excel Excel Charting Excel Excel Tips Excel Formulas excel tip Excel Tip Category Excel Tips Excel Tips& Tricks excel tutorials Excel Videos Excel Video Tutorials formatting Formula formula friday Formulas macro Macro Mondays Macros Pivot Table Pivot Tables Power BI Power Query Tutorials vb VBA Worksheets

Recommended Excel Resources

Free Excel Dashboard Webinar

Copyright © 2021 · Enterprise Pro Theme on Genesis Framework · WordPress · Log in

Popular Pages

  • Home

More Info

Want FREE Excel Tips?

Click on my FREE eBook, its my bonus for joining thousands of others who receive my 3 xFREE Excel tips every month in my Excel Newsletter. Join Us!.

Need Answers To Excel Questions Like These?

*How Do I Create A Timestamp In Excel?
*I Want To Change The Width Of The bars On My Excel Chart
*How Can I Find Out The Length Of My Text in Excel? Click the link below to receive more Excel tips' and my Free Ebook

New To Excel? This Is A Great Place To Start!!

Learn Excel Dashboard Course Excel Basics
Scrollbars
Colour of Sheet Tabs
Conditional Formatting
Calculations Introduction

Excel Charting

Self Expanding Charts
One Click Charts
Create Quick Dynamic Charts
Easy Combination Charts

Video Tutorials-If You Like To Learn By Watching

Subscribe to YouTube to get notified of of new Excel videos.


Self Expanding Chart
Delete Obsolete Items From A Pivot Table-Excel 2007
What Are Pivot Tables- Create Your First One
Enable The DeveloperTab In Excel

Some Fun Stuff

Pivot Table Song

Navigation

  • Formulas
  • Excel Tips & Tricks
  • Excel Charting
  • Tutorials
  • VBA
  • Book Store
  • Top Menu

Follow Us

Search

© howtoexcelatexcel.com. All rights reserved.

  • Privacy Policy