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

Excel Formatting Trick To Merge without Merging.

January 12, 2021 by Barbara

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 Prevent Users Printing An Excel Workbook

November 30, 2020 by Barbara

Welcome back Excellers to another #MacroMonday in my Excel 2020 series. Today, I will show you how to prevent users from printing an Excel workbook. This blog post is in response to a request for this Excel solution from a subscriber. The solution to this was to write a very basic and simple Excel VBA Macro. I thought it would be a useful share with you all. Don't get scared off, its a little Visual Basic (VB) for Excel. It is straightforward. Why not give it a go?. The request was to … [Read more...]

Filed Under: Macro Mondays, Macros, Tutorials, VBA Tagged With: Blog, Macro Mondays, Macros, VBA

Turn Of The Double Click Drill Down In Your Pivot Table.

November 11, 2020 by Barbara

Hello, Excellers welcome back to another blog post with an Excel Pivot Table Tip. In today's blog post let'stake a look at how to turn OFF the option of a user Double Clicking in your Excel Pivot Table to drill down into the data.  Drill Down Into A Pivot Table. By double-clicking on the data in the Values Area of your Pivot Table you can extract the underlying records These are the records that make up that data.  See the screencast below for an example.  (You … [Read more...]

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

IF Statement For Last Day Of The Month.

October 23, 2020 by Barbara

Hello, Excellers and welcome back to another #FormulaFriday #Excel blog post in my 2020 Excel series.  Today I want to answer a question that a subscriber sent to me.  If you want to ask any questions or comment feel free to leave a comment below.  The question was, how to use the IF Function in Excel to identify if a cell contained the last day of the month.  So, why did they want to know this?.  Well, on the last day of the month, They Wanted to automatically insert … [Read more...]

Filed Under: Blog, Formula Friday, Formulas, Tutorials

Excel Tip. Automatically Add New Items To Drop Down Lists

August 28, 2019 by Barbara

Hi Excellers, welcome back to another #Excel tip. Today I want to show you how to set up a data drop-down list that is automatically updated when we add new items or options to the list.  Dropdown or data validation lists are really useful when you want to control data entry into your Excel workbook.  By giving the user limited options, you control the quality of the data that the user enters. You can follow these simple steps to make your drop-down lists dynamic, so they update … [Read more...]

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

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

  • VBA
  • What Is Power Query For Microsoft Excel?

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

  • Twitter
  • Facebook

Search

© howtoexcelatexcel.com. All rights reserved.

  • Privacy Policy