归档： Sandra
-
How To Recover Deleted Files from Recycle Bin After Emptied
If you accidentally delete a file or folder, you wouldn’t be nervous, because you know how to restore deleted files from Recycle bin. All you need to do is find the file in the Recycle Bin and right-click it to choose the Restore button to recover it. There is another scenario, the recycle bin had […]
-
How to Print Large Excel Sheets?
We can print a long Excel sheet into several pages, but how to print a wide Excel sheet on one page? Here is a fruit price table. Now we select the table area and press Ctrl and P to print it. There is no doubt that the table is too wide to print completely. It […]
-
How To Move Excel Columns? (Super Easy Tutorial)
What? Someone is stilling cut and paste columns in Excel to change the columns’ place! Come on, just press and hold the Shift key on your keyboard can handle this. Here are three columns. Now, let’s move Excel column C into the first column position. Select the area of column C and put your cursor […]
-
How To Auto Fill Color in Excel Based on Key Words?
We usually use Ctrl and F to quickly find the content we need in Excel. There is a function that can also help us to find something by keywords and even filling color to tell from other cells. So, how to auto-fill color in Excel? Let’s check this out. Here is a full name list. […]
-
How to Copy Only Visible Cells in Excel
We may filter or hide columns/cells rows to classify or analyze data easily. But copy and paste can not work normally in this situation. For example, how to copy only visible cells in Excel? Let’s check this out. Default copy and paste with hidden cells in Excel. Here is a score table for classes […]
-
How to sum by color in Excel?
Supposing we have a vegetable sales table as below, and we need to count or sum the colored cells. Is there any fast way to deal with this? So how to sum by color in Excel? Let’s check this out! Method 1: Click on any cell and press Ctrl and F to open the Find […]
-
How to Fix Error Code 0×8007007e in Windows 10
Have you ever met such an error code 0×8007007e in Windows 10? Today, I’m going to print some webpage, then the error 0x8007007E appears. The error 0×8007007e usually appears when software and drivers are not compatible with the update you’re trying to install. To resolve the error, we can do as following. Press the Win […]
-
How to Fix Weird Font Problem in Windows 10?
One time, I just emptied the D drive of my computer and rebooted it, then the fonts on my computer became so strange. I know that our computer has smooth fonts by default. But sometimes it would be changed, so how to fix weird font problem in Windows 10? How to improve the look and […]
-
How to Sum Every Other Column in Excel?
In our last tutorial, we learned the way of how to sum every other row in Excel. Let’s continue this in the second part, knowing how to sum every other column in Excel. Here is a random number table. Let’s get the sum of the odd columns as the screenshot below first. Type this =SUMPRODUCT((MOD(COLUMN(A1:G10),2)=1)*A1:G10) […]
-
How to Sum Every Other Row in Excel?
As we all know, the sum function can help us easily get the sum of a row or column, or even an area. But on special occasions, we need to sum up every other row in Excel. So, this is today’s point, how to sum every other row in Excel? Let’s take an example. Here […]
