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

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

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

How To Fit Longer Text Into Excel.

October 6, 2020 by Barbara

Hello Excellers. Welcome back to another Excel Tip. Today I will show you how to fit longer text into Excel. This is a simple trick. I have been asked this question recently so thought it was worthy of a short Excel blog post. Do you ever have a long line of text in Excel?  It may look at bit like my screengrab below. Sometimes if you have a free text notes column or even longer names or addresses you end up with text running over multiple Excel cells. So, if you look at … [Read more...]

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

How To Use The Quick Analysis Tool In Excel.

September 29, 2020 by Barbara

From Excel 2013 onwards, the quick Analysis Tool makes it really easy to analyse your data quickly and easily. It contains a variety of Excel tools. The tool can be used with data from a range of cells or an Excel data table. How To Access The Quick Analysis Tool. So, it is really easy to get started with the Quick Analysis tool. Once you select a range of cells or an Excel data table, the tool appears at the bottom right of your data set. A range of analysis tools is now available to … [Read more...]

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

Excel Tip. Copy A Worksheet And Create A New Excel Workbook.

August 16, 2020 by Barbara

Hello, Excellers. Time for another Excel tip. I want to share with you a question from a subscriber.  How to copy a worksheet It is going back to basics.  They needed to take one worksheet from a sales workbook and create another workbook with just that one worksheet.  They previously had been making a copy of the workbook and then deleting the extra unnecessary worksheets they did not need.   Copy Your Excel Worksheet. There is a quick and easy way to do … [Read more...]

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

  • 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

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

Quick Links

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

© 2021 howtoexcelatexcel.com - All rights reserved.
  • Privacy Policy