Save Table as Image Excel with Just 3 Simple Steps

On

 


This is a skill in Excel that you should have. It is highly applicable in your daily work.

Here are 3 simple steps, keep in mind and put them into practice.


➠ Follow & send us a message on QTitHow for answers to IT issues.


How to do:

Step 1: Select the data area in the Table that you want to save. Select Copy > Copy as Picture



Copy the data area in the Table


Step 2: A window will appear - Copy Picture, keep the default settings and press OK




Step 3: Open the Paint program in Windows. Then Paste directly into Paint. Finally, adjust the length and width to suit and save it as an image file (PNG or JPG).


Paint program on Windows




Save as PNG or JPG


In addition to being able to save as an image file as above (in step number 3), you can Paste it directly into Email on Outlook, Word, Power Point... (data after Paste will be in the form of an image).


Conclusion:

With the above 3 steps, you can process data on Excel much more flexibly. Thank you for following the article.

Export Graph/Chart from Excel to PDF

On

 


Have you ever had a situation where you have to save all charts or graphs on an Excel report file to a PDF file (not including the content/text on the file)? I have already met.

In many cases you just want to display loud and clear charts/graphs to view and compare them. This article is the solution for you. In this tutorial I will guide you in 2 parts:


Part 1: Save/Export one chart/graph from excel to PDF file
Part 2: Save/Export multiple charts/graphs from Excel to PDF file.

(Note: Before doing this please back up the original excel file.)


➠ Follow & send us a message on QTitHow for answers to IT issues.


How to do:


Part 1: Instructions to save/export one chart/graph from Excel to PDF

Step 1: Right-click on an empty area on the chart/graph in the Excel file which you want to export it.

Step 2: Select Move Chart... A Move Chart window appears, click New sheet. Then press OK.


Move chart function on Excel


Click New sheet

Step 3: Now the selected chart will be transferred to a new sheet named Chart 1. Next, click File > Save as (Save a copy) > Save as type = "PDF".


One new sheet "Chart 1" be created



Save as type to PDF

Done, you have finished exporting or separately saving a desired chart/graph from an Excel file to a PDF file.


Results:  save/export one chart/graph from Excel to PDF


Part 2: Instructions to save/export multiple charts/graphs from Excel to PDF

Step 1: Please do steps 1 & 2 (of part 1) for all the charts you want to export to PDF file.

Step 2: Click to select all the newly created sheet charts (in the example below choose: chart 1, chart 2).

  1. To select multiple adjacent chart sheets in the Sheet bar, please hold the Shift key and click the first chart sheet and the last chart sheet;
  2. To select multiple non adjacent chart sheets in the Sheet tab bar, please hold the Ctrl key and click each chart sheet one by one.


Step 3: Same as step 3 of part 1.

Done, now all charts/graphs have been saved on the PDF file.


Results: save/export multiple charts/graphs from Excel to PDF

Conclusion:

This trick is pretty cool, isn't it, it helps you to export charts/graphs to a pdf file with a large size and very clear display (without text).


Maybe you are interested?

Is it possible? Export all images at once on Excel file

On

 


The usual way you save images from an Excel file is to use the Save as copy feature on Excel, is that correct?

However, in case an Excel file has a lot of images and you want to save all those image files in one folder. So what do you have to do to be the best? If you use the Save as copy method one by one, it will take a lot of time and difficulty.


For example, an excel file contains a lot of pictures


As the title of the article "Is it possible? Export all images at once on Excel file" - The answer is YES!

Please read and memorize this trick. The steps are as below.


➠ Follow & send us a message on QTitHow for answers to IT issues.


How to do:

Step 1: Click File > Save as




Step 2: Select Browse to save the Excel file. A window will appear, do the following:

  • Select location to save
  • Set name the File name
  • In the Save as type section, select Web page. Selecting Web page will help you save all the images on that Excel file in a separate folder.


Step 3: Click Save button. In the popping up Microsoft Excel dialog box, click the Yes button.



And this is the result:

All of images in Excel file will save at image_files folder

Conclusion

Too fast, too easy, right? With only 3 simple steps, this trick helps you to save all images on Excel file quickly and without leaving any image.


Maybe you are interested?


How to Move/Copy Worksheet to another Workbook

On

 



Today I will share an Excel trick that you will use often in work and study: How to copy Worksheet from 1 Workbook to another Workbook?

The important thing here is that you will have to copy the entire content and format of that WorkSheet to another Workbook: data, date format, columns, rows, colors... See detailed instructions below.


➠ Follow & send us a message on QTitHow for answers to IT issues.


How to do:


Step 1: Open all the Workbook that you will be working on.

Step 2: On the Workbook containing the Sheet you want to copy, right-click on that Sheet and select Move or Copy...




Step 3: In the To book section, select the Workbook you want to copy to. As in this example, there are 3 choices as follows:

  • New book: Excel will automatically create a new Workbook and will copy it to this new Workbook.
  • Workbook 1: It will create 1 more Sheet like Sheet 1 at Workbook 1 (this case is like you duplicate 1 sheet at 1 workbook so).
  • Workbook 2: This is the Workbook you have already opened, it will copy Sheet 1 to Workbook 2 (This is the most commonly used option).




Step 4: In the Before sheet section, you can choose where the Sheet will be copied on the Workbook.

You can completely specify which Sheet it is in front of you want. Normally, we would choose (move to end). To easily find the Sheet that we just copied.



Step 5: Click Create a copy. After that click OK to complete.




Important Note:

  • You must open all workbook that you will work with, including the workbook containing needed worksheets, and the workbook you will insert the worksheets to. Otherwise, you will not find out the workbook names in Step 3.
  • You must check the Create a copy option in Move or Copy dialog box, otherwise you will move the selected worksheet out of original workbook.

Conclusion: 
With this trick, you can copy any sheet to any Excel - Workbook file you want. Very useful, right?

How to Import data into the Excel file from a Text file or CSV file

On


Hello everyone, this article will be the first in a series of essential Excel tips (often used in study and work). Hope everyone will always follow and support QTitHow.

In many cases you need to import data into the Excel file from a text file or from a CSV file.

In fact, the data you receive is in a simple text file, and your wish is to convert that text file into an Excel file (with rows and columns) for you to easily manage and use. This article will guide you to do that.


➠ Follow & send us a message on QTitHow for answers to IT issues.


How to do:

Step 1: Open a new Excel file (new Workbook). Switch to the Data tab, select From Text/CSV.



Step 2: A window will appear, please select the existing text file > Click Import (or double click on the selected file). The data on your text file will be displayed as below.



Step 3: Next step, choose Delimiter to match the content of your text file. Commonly used delimiters: colon - ":", comma - ",", equal sign "=", semi colon - ";"...

For example, in this case, the data fields are separated by semicolons.



Step 4: Click Load to import the data into the Excel file. This is the result.


The data on the excel file after being imported from the text file will be in Table format.

Some more features explained:

  • You can define your own delimiter and choose Custom to import the data.
  • Refresh feature: restore all original values, including delimiter entries.
  • Transform feature: Used to adjust some information before you perform step 4. Adjustments such as rows, columns, data,...

Use Transform feature to adjust rows, column, data...

Attention:

  • The data on the excel file after being imported from the text file will be in Table format.
  • You can import data from a CSV file (Excel sheet). The method is similar to the text file.

Conclusion:
The above are just extremely basic instructions when you want to import data into an Excel file from a Text or CSV file. If you have any questions please leave a comment below. Thank you!

Security Update KB5011487 fix issue Microsoft OneDrive

On

 


 

Overview

On March 08 2022, Microsoft is released the update KB5011487 for devices running Windows 10 21H2, 21H1, and 20H2 with several fixes and improvements.

 

➤ How to check for updates on Windows 10

 

Run Windows Update KB5011487 on Windows 10

 

Improvements and fixes

This security update includes improvements that were a part of update KB5010415 (released February 15, 2022). Plus, it will fix the following problem:

"Addresses a known issue that occurs when you attempt to reset a Windows device and its apps have folders that contain reparse data, such as Microsoft OneDrive or Microsoft OneDrive for Business. When you select Remove everything, files that have been downloaded or synced locally from Microsoft OneDrive might not be deleted. Some devices might take up to seven (7) days after you install this update to fully address the issue and prevent files from persisting after a reset. For immediate effect, you can manually trigger Windows Update Troubleshooter using the instructions in Windows Update Troubleshooter"


This is official information from Microsoft. With this improvement, it will help users who are using online storage applications such as Onedrive, Ondrive for Business...


How to remove update 

Method 1: Windows users can remove the KB5011487 updates using the Command Prompt.

>> You can see detail guide remove update on Windows 10 by Command Prompt

Method 2: Use Settings to remove KB5011487 update.

>> You can see detail guide remove windows update by Settings

Method 3: Use DISM tool to remove KB5011487 update.

>> You can see detail guide remove windows update by DISM Tool

 

Information about update 

Release Date: March/08/2022 

 

Pay attention

In case you can't install this update and get an error. Please remove the update.

 

REMINDER from Microsoft:
Windows 10, version 2004 reached end of servicing on December 14, 2021. To continue receiving security and quality updates, Microsoft recommends that you update to the latest version of Windows 10.

To update to one of the newer versions of Windows 10, please download and install as below:

Important: Use EKB KB5003791 to update to Windows 10, version 21H2.
Important: Use EKB KB5000736 to update to Windows 10, version 21H1.
Important: Use EKB KB4562830 to update to Windows 10, version 20H2.

 


Tips for Windows 11: How to show Weather Widget on Taskbar

On

 


Unlike Windows 10, Windows 11 currently does not have News and Interests functionality. This is an interesting and useful feature for users on Windows 10.
However, with Windows 11 you will not see this feature anymore. Instead are Weather, News, Top Stories... located in the Widget. This article will help you display the Weather feature on Windows 11 with just a few basic steps.


How to do:

To display the Weather feature on the Taskbar, please install the Taskbar in the middle of the screen as the default below. If the Taskbar is on the left side of the screen. Please reinstall it.  

 

➤ How to move Taskbar & Start Menu to the left or center in Windows 11

 

Make sure the taskbar is installed at the center of the screen.


Step 1: Right click to Taskbar. Choose Taskbar settings.

 


 

Step 2: Go to Personalization on the left side, and then find to Taskbar items.

Step 3: Please turn on Widgets. Please wait 1-2 mintutes to system to update Weather widget on left corner side.

 

Turn on Widgets


 Weather info will be display on the left side of Taskbar

Conclusion:

With 3 simple steps, you can enable or disable the Weather feature as you like. If this post help to you, please like and share it. Thank you.

How to move Taskbar & Start Menu to the left or center in Windows 11

On

 


The biggest difference between Windows 11 and Windows 10 is the location of the Taskbar and Start Menu. For Windows 11, the default location will be in the center of the screen where your eyes tend to go on your display. However, you can still adjust their position to the left like Windows 10. This post help to you do it.

 

➤ How to remove "Transparent box" on Taskbar

➤ 3 Outstanding improvements in KB5010414 update on Windows 11 

 


By default, the Taskbar is in the middle of the screen

 

How to do:

Step 1: Right click Taskbar. 



Step 2: Go to Personalization category on righ side. Click to Taskbar 

 


Step 3: Find to Taskbar behaviors category. From here, look for Taskbar Alignment. Please choose Left

 

  

Finished. Now, Taskbar and Start Menu move the left side. 

 

Taskbar & Start Menu on the left side (same as Windows 10)

 

Note: When you move the Taskbar and Start Menu to the left, the Weather widget feature will disappear on Taskbar as normal. And if you want to show Weather, please move it on the center.


➤ How to show Weather Widget on Taskbar


Conclusion:

This is 3 steps help to you move Taskbar & Start Menu to the left in Windows 11. If have any question, please contact me by fanpage QTitHow. Thank you.

Subscribe to: Posts (Atom)

Copyright © 2016 QTitHow All Rights Reserved