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

Excel Formatting Trick To Merge without Merging.

January 12, 2021 by Barbara —Leave a Comment

Hello Excellers, and welcome back to another #Excel blog post in my 2021 series. Today I will show you how to achieve the same effect in Excel, without actually merging cells in Excel. Confused?. Don't be. Do you use merged cells in your Excel worksheets?. Have you come across issues when you try to write formulas such as XLOOKUPS and VLOOKUPS. Well, those merged cells are probably causing the issues. We can use Center Across Selection as a great alternative. Some while users love … [Read more...]

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

How To Enable And Disable Macros In Excel.

January 4, 2021 by Barbara —Leave a Comment

Hi, Excellers. Welcome back to another blog post in my new year of 2021 #MacroMonday Excel series. Today let's take a look at how to enable and also disable Macros in Excel. Now, Excel Macros can be used for good or not so good. So, as a consequence, you have a choice to enable them or disable them in Excel. We can also store them in trusted locations. With the release of Excel 2010, the security model changed significantly to previous versions. It introduced the concept of 'Trusted … [Read more...]

Filed Under: Blog, Macro Mondays, Macros, VBA Tagged With: Blog, Excel Tips, Macros, VBA

Macro Mondays – Insert A Blank Row After Every Row In The Selection.

December 28, 2020 by Barbara —Leave a Comment

Hello, Excellers welcome again to some more #MacroMonday Excel macro fun.  I will who you how to insert a blank row easily into your Excel worksheet. Repeating this over and over again is very laborious. So, let's take a look at automating with Excel VBA. This is an Excel query that one of my colleagues had to carry out manually every week. They needed to insert a blank row after every row in their range of cells.  The range of cells which need a blank row inserted can vary in … [Read more...]

Filed Under: Blog, Macro Mondays, Macros, VBA Tagged With: Blog, Excel Tips, Macros, VBA

How to Delete Obsolete Items In Your Excel Pivot Table

December 21, 2020 by Barbara

Welcome Excellers to another #Excel #MacroMonday blog post in my 2020 series. Let's look at creating another Excel VBA Macro to delete obsolete items from your Excel Pivot Table. Let's speed up our Excel life. If like me you reuse Pivot Tables over and over again. Sometimes, your data source changes or products no longer being sold or one of your salespeople no longer working for you. You may find this happen especially if you use your Excel Pivot Table as a template that when your data is … [Read more...]

Filed Under: Blog, Macro Mondays, Macros, VBA Tagged With: Excel Tips, VBA

Show Value And Percent In Same Report- No Formulas!

December 11, 2020 by Barbara

Hello, Excellers. Welcome back to one of the last #FormulaFriday Excel blog posts of 2020. Often you will need to display a value as well as percent in the same report. So, more formula (or no formula in this blog post) fun. Today I will show you how to avoid using formulas to do this! Yes, that is right it's not formula Friday really. We go back to one of the best tools in our Excel took kit, the Pivot Table. So, let's quickly build a Pivot Table using a sample data set. A … [Read more...]

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

  • 1
  • 2
  • 3
  • …
  • 84
  • 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

 

Search

Navigation

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

Social

  • Twitter
  • Facebook
© 2021 howtoexcelatexcel.com. All rights reserved.
  • Privacy Policy