Skip to content
EasyTweaks.com
  • Home
  • Online Collaboration
  • Outlook
  • Python Automation
  • Data Analysis
  • Data Visualization
  • Excel
  • Office Automation

Microsoft Excel

Microsoft 365 Excel Macros for beginners: How to record and write VBA Macros in your Excel 2019 workbooks?

Post updated: August 2021 Here’s a reader question: I have a co-worker that is using Excel VBA Macros to analyze a bunch of data. Can you explain how Macros work, and probably suggest a way for me to pick that skill up? Any simple tips for beginners are very much appreciated. Thanks for the question. … Read more

Categories Microsoft Excel Leave a comment

How to import data from Excel into an Access database?

Applicable to: Office 2019/2016/365 Here’s a question from Mike: “I know how to create Access forms and capture user input into a database table, but as i have already gathered  there a way to automatically import data from an Excel workbook into an Access database table instead”? Good question, Thanks. Yes, you can automatically import … Read more

Categories Microsoft Excel Tags Import Excel to Access 2016 Leave a comment

How to access and open an Excel 97/2003 .xls file in Excel 2016, 2019 and 365?

Last updated: May 2020 Applicable to: Microsoft Office Excel 365, 2019, 2016, 2013, 2007. Windows 7 and 10 operating systems. Skyler set us a note about her Microsoft Excel spreadsheet not opening: “I work as an analyst and have a significant number of old .xls files were created in the previous versions of Excel. Now … Read more

Categories Microsoft Excel Tags Open xls file in Excel 2016 4 Comments

How to make Office 2016 or 2019 or 365 your default Microsoft Office application?

Last updated: November 2021 Applicable to the following Office versions: 2019, 2016, 2013, 365; on Windows 7, 8 and Windows 10. Here’s a question we received from one of our readers: “I’ve just installed a new version of Office 365 in my system but it’s clearly not defined as the default program for viewing and … Read more

Categories Microsoft Excel Tags Set default office programs 4 Comments

How to combine two or more cells or columns in Excel 2016 / 365 / 2019?

Here’s a question from Nanda: “I need to copy list of names available in spreadsheet into a simple text document to then import it into a legacy information system we use at work. But when I copy the Excel columns to the clipboard and then paste in Notepad, it all goes wrong. Can you help … Read more

Categories Microsoft Excel Tags Concatenate function in Excel 2016 Leave a comment

How to embed Word objects into an Excel 2016 / 365 / 2019 workbook?

Applies to: Windows 11, 10, 8 and 7 and macOS operating systems. Dorothy wanted to learn how to insert objects into her Excel spreadsheets: I believe i have seen a Microsoft Excel worksheet that had a Word document embedded in it. Can you explain how can i insert Word files into Excel and in general … Read more

Categories Microsoft Excel Leave a comment

How to remove password protection from Excel 365 / 2016 / 2019 workbooks?

Updated: October  2019 Applicable: Microsoft Excel 2019/365/2016; Windows and macOS operating systems. Here’s a question we got: Dear Team – some time ago i have created a quite sophisticated Excel spreadsheet for my manager which i password protected for increased security. The thing is that it seems that i have forgotten the password which i … Read more

Categories Microsoft Excel Tags Excel 2016 3 Comments

How to spell check in Excel 2019 / 365 and 2016 (automatically and manually)?

Applicability: Office 2019, 2016, 2013; Office 365 and Standard. Here’s a question that we received a few days ago: I am currently using Excel 2016 on my Windows 10 based computer. As i am quite a fast typist, i often accidentally make quite a bit of spelling mistakes. For some reason i expected that Excel … Read more

Categories Microsoft Excel 1 Comment

How to split worksheet cells by half in Excel 2016 / 2019?

Applicable to: Office 2019, 2016, 2013; 365 or standard Here’s a question that we have received from a reader who wanted to divide an Excel column vertically: I am working on a statistical report in Microsoft Excel, using version 365. I just imported a comma separated value fileĀ  into the A column andĀ  now need … Read more

Categories Microsoft Excel Leave a comment

What program will allow me to open an xlsx file on Android, iPhone, MAC and PC?

Dave, who read my post on how to open a pptx file approached me with a similar question. Few days ago, a friend sent me a file with the xlsx suffix as an attachment on GMail. I access my email online via my Samsung Galaxy phone, iPAD and MAC OS X High Sierra computer. I … Read more

Categories Microsoft Excel Leave a comment
Post navigation
Newer posts
← Previous Page1 Page2

Recent Posts

  • How to fix typeerror can only concatenate str (not “bytes”) to str in Python?

  • How to fix the TypeError: string argument without an encoding error in Python?

  • How to check if a cell in Google Sheets contains specific text or values?

Search Easytweaks.com

© 2007-2023 by EasyTweaks.com. All rights reserved. Posts in this site may contain affiliate links.
Contact Us || Sitemap || Privacy || Terms of Service