Skip to content
Search
  • Home
  • Microsoft 365 Guides
    • Microsoft Teams
      • Teams Guides
      • Teams Troubleshooting
    • SharePoint
      • SharePoint Guides
      • SharePoint Troubleshooting
    • Outlook
      • Outlook Guides
      • Outlook Troubleshooting
    • OneDrive
      • OneDrive Guides
      • OneDrive Troubleshooting
    • Microsoft Excel
      • Excel Guides
      • Excel Troubleshooting
    • Microsoft Word
      • Word Guides
      • Word Troubleshooting
    • PowerPoint
      • PowerPoint Guides
      • PowerPoint Troubleshooting
    • Windows
      • Windows Guides
      • Windows Troubleshooting
  • Apple Guides
    • MacOs
      • MacOs Guides
      • MacOs Troubleshooting
  • About Us
  • Contact Us
  • Privacy Policy

Category: Excel Guides

link to How to export lists from SharePoint to Excel with filters

How to export lists from SharePoint to Excel with filters

If you have a large amount of information stored in a SharePoint list or an Excel spreadsheet, you may find that filters are a great way to refine this information so you can easily locate specific...

Continue Reading
link to How to make all cells the same size in Excel

How to make all cells the same size in Excel

Spreadsheets allow us to structure, assess, and manipulate large amounts of data. And we can ensure our spreadsheets are clear and readable by using formatting tools. But if you neglect to format...

Continue Reading
link to What does “the data you’re pasting isn’t the same size as your selection” mean?

What does “the data you’re pasting isn’t the same size as your selection” mean?

Copy and paste is an effective way of transferring data from one location to another. But it's not always a straightforward process. For example, you may find that "the data you're pasting isn't the...

Continue Reading
link to How to get day name from date in Excel

How to get day name from date in Excel

Dates allow you to track when an event occurs. However, a date is not always specific enough. After all, if I asked you what day the eighth of December 2032 would be, you probably wouldn't guess it's...

Continue Reading
link to How to remove dashes in Excel

How to remove dashes in Excel

If you're transferring a form into a spreadsheet, you may run into formatting problems from time to time. Fortunately, Excel features several handy tools that will allow you to clean everything up in...

Continue Reading
link to How to freeze top row and the first column at the same time in Excel

How to freeze top row and the first column at the same time in Excel

Excel uses a system of rows and columns to help users organize information within a document. Excel offers its users an abundance of different features to allow for better data management within the...

Continue Reading
Page 1 Page 2 Page 3 … Page 10 NEXT »

About Us

Here at Business Tech Planet, we're really passionate about making tech make sense. In a world where businesses are embracing technology more than ever, it's essential you understand the tech you're using. We've created this blog to share our knowledge and make tech simple, so you can make use of all the fantastic technology available to your business.

Important Legal Information

Business Tech Planet is owned and operated by M&D Digital Limited, company number 12657448. Business Tech Planet is a participant in affiliate advertising programs designed to provide a means for sites to earn advertising fees by advertising and linking to affiliated sites. Business Tech Planet is compensated for referring traffic and business to these companies.

  • Privacy Policy
  • About Us
  • Contact Us
© 2023 Copyright Business Tech Planet

Business Tech Planet is owned and operated by M&D Digital Limited, company number 12657448. Business Tech Planet is a participant in affiliate advertising programs designed to provide a means for sites to earn advertising fees by advertising and linking to affiliated sites. Business Tech Planet is compensated for referring traffic and business to these companies.