2023-06-21 04:03
I understand that you’re facing difficulty accessing a password-protected Word document. While it can be challenging to recover a password without the necessary information or tool… Read More
Blog Directory > Technology Blogs > MyOfficeTricks technology Blog >
Myofficetricks Blog
myofficetricks.com
Tags:
excel
mouse
cursor
path
hiding folders
delete cookies
columns
powerpoint
office
microsoft excel
MyOfficeTricks mainly shares free tutorials for MS Office and tips about working at office.
2023-06-05 10:11
Screen recording is a useful feature in PowerPoint that allows you to capture and share your screen activity with others. However, sometimes it may encounter issues, such as the selected are… Read More
2023-04-20 09:11
When using a computer, privacy, security, and organization are key aspects to consider. Whether you share a computer with others, store sensitive information, or simply want a tidy desktop… Read More
2023-03-17 08:16
Office 2021 and Windows 11 are the latest versions. Office 2021 offers five gigs of free storage, which makes up for the lack of storage provided in the previous version. Now we can do… Read More
2023-03-01 15:27
Cookies are files created by websites that you go to. They save browsing information to make your online experience easier. Clearing the cache and cookies from a web browser is an important… Read More
2023-02-24 15:28
The usage of
shortcut keys or Excel functions may be the main tricks you guys want to learn.
But some cool Excel tricks and tips would be interesting or not so
humdrum. Let’s get start… Read More
2023-02-19 09:20
Excel functions can help
us to improve our work efficiency a lot. In today’s tutorial, we’ll learn how
to use the match function in Microsoft Excel.
The Match function
search… Read More
2023-02-15 15:16
Are you tired of using the same plain cursor? We can customize our mouse in a variety of ways in Windows. So how to custom cursor for windows? We’ll learn the easiest way.
Pres… Read More
2023-02-11 16:02
There’s an awesome
tutorial for today! We can set file path in Excel. Many people aren’t familiar
with this. So, let’s get started.
Step 1 Open a new Excel worksheet… Read More
2023-02-07 15:16
How to do when you don’t take your mouse or your mouse is broken? Actually, the keyboard can be used as a mouse. So how to use the keyboard as mouse?
Press the Alt+Shift+Num Lock ke… Read More
2023-02-03 03:28
Sometimes our computer fails to connect to the printer. And we’ll get an error message: “Windows cannot connect to the printer.” So how to fix “Windows cannot connect… Read More
2023-01-28 01:59
In our daily use
of Microsoft Word, we usually have our own favorite font. The author will share
with you guys a way to quickly change the font, that’s set shortcut keys for
your commo… Read More
2023-01-23 01:39
Using shortcuts can help us greatly improve our work efficiency. There are many kinds of shortcuts, F5 is one of the most useful but often overlooked shortcuts.
Pressing the F5 key will d… Read More
2023-01-16 15:25
Dynamic Host Configuration Protocol (DHCP) is a
network protocol that allows a server to automatically assign an IP address to
your computer. So how to enable DHCP Windows 10? Just
keep… Read More
2023-01-05 15:47
Excel’s Find and Replace commands could help us a lot. When you have a word or number you need to find somewhere or replace some content in your worksheet. Sometimes, we need to replac… Read More
2022-12-30 15:49
Microsoft
Word tips can always
improve our work efficiency and save much time, in our today’s post, we’ll
learn several Microsoft Word tips and tricks about Word table. Let&rsquo&hell…Read More
2022-12-25 16:15
If you want to take a screenshot on Windows 10 computer, whether capture the full screen or just one window or area or even a screenshot that is grotesque in shape. There are several methods… Read More
2022-12-20 16:04
In our previous tutorial, we learned how to extract numbers from text in Excel cells.
In our
today’s sharing, we’ll keep learning something about this. That’s how to… Read More
2022-12-16 15:38
Sometimes we need to print an Excel worksheet and sign on it. So, underlining blank space after the text is essential. in our today’s tutorial, we are going to learn a method to quickl… Read More
2022-12-11 16:53
You may find a word document with many WordArt watermarks. or just WordArt as text. In today’s tutorial, we are going to learn how to remove all WordArt in Word documents.
Here is a… Read More
2022-12-06 15:19
Wi-Fi is everywhere, and our windows laptop remembers every Wi-Fi network you’ve accessed with it. So, we can find Wi-Fi password on windows 10 when we forget it.
Press the Win and… Read More
2022-12-02 16:07
The Excel sheet
direction is from left to right by default. But you can change the Excel
sheet from right to left if required. There is an easy way can do this in
seconds.
Here is a frui… Read More
2022-11-28 15:26
If you need to know what version of Windows your computer is running. This post can help you to know how to check Windows version in several ways. Let’s check it out.
Method 1
Ri… Read More
2022-11-24 15:22
If you are always typing your company name repeatedly, or a very long name in Excel. You can actually use a very quick way to avoid typing repeatedly.
Go To File And Choose Options… Read More
2022-11-20 15:30
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… Read More
2022-11-16 16:02
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 prin… Read More
2022-11-12 16:20
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 c… Read More
2022-11-08 15:02
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 cell… Read More
2022-11-04 15:39
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?… Read More
2022-10-30 15:53
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… Read More
2022-10-25 15:08
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 u… Read More
2022-10-21 15:47
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 w… Read More
2022-10-17 16:39
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 ra… Read More
2022-10-13 16:15
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&r&hell…Read More
2022-10-09 16:23
In our
today’s tutorial, we’ll learn how to get age from birthday in Excel. We of
course make a formula to compute the ages quickly. Let’s check this out.
Here is a work… Read More
2022-10-05 15:11
Are you looking for one software to help you send emails in bulk? Someone may say that just need to save these email addresses into a group and then mail them. Come on, every ema… Read More
2022-10-01 16:32
There are many kinds of charts. Different charts present different effects. The bubble chart can visually show the relationship between the three variables. In this article, I will introduce… Read More
2022-09-27 16:40
It’s inevitable that we need to go to the bathroom or make a cup of coffee or go to a meeting in the workplace. To prevent our computers from being viewed or manipulated by others, lo… Read More
2022-09-23 16:02
Have you got the usage of the CHOOSE function in Excel? We learned this in our last post. We will continue to use this function today. Suppose we need to get a list of random serial numbers… Read More
2022-09-19 15:56
Powerful Excel functions can always save us much time, in our today’s tutorial, we are going to learn a new Excel function—the CHOOSE function.
The Excel CHOOSE
function retur… Read More
2022-09-15 16:55
We usually add borders to cells by clicking on the borders button. Have you ever tried to add borders automatically on your worksheet while you are entering values in a cell? This trick can… Read More
2022-09-11 15:08
Why there’s only a cursor on your desktop screen when you start up your computer? So, in our today’s tutorial, we’ll learn how to solve this problem. Let’s check this… Read More
2022-09-07 15:55
We learned how to extract images from PowerPoint in the last tutorial. But do you know how to save a PowerPoint slide as an image? Here we go.
Go to the File and click on Save a… Read More
2022-09-03 15:28
Are you still right-clicking and saving the pictures in PowerPoint one by one? if you want to extract only one or two images, you can save them in this way, but if there are lots of pi… Read More
2022-08-29 15:02
Most of us would not set the background color of the slide. Or just set a pure color. Actually, we can create a gradient effect to beautify our PowerPoint slides.
Go to the Design tab and… Read More
2022-08-24 15:23
In our today’s tutorial, we’ll learn how to remove multiple hyperlinks from an Excel worksheet at the same time.
If we want to remove hyperlinks but keep the text. We can sele… Read More
2022-08-20 15:17
When we talk about the filters in Excel, many people know that it can quickly find information or data that fits certain criteria in the clutter.
In addition to the filter, there is a fea… Read More
2022-08-14 15:55
We’ve known how to create a dynamic graph in Excel. In our today’s tutorial, we are going to know how to create a dynamic table in Excel.
Here is a fruit sale table from Mond… Read More
2022-08-09 16:12
Duplicates would be one of the reasons for wrong data entry. So, how should we prevent duplicate entries in Excel when entering data?
Let’s take an example.
Here is a school repo… Read More
2022-08-06 16:02
We have learned a tutorial on how to compare two Excel worksheets side by side.
But if we want to compare two tables in Excel, I mean the two tables are in one Excel worksheet, is there a… Read More
2022-08-02 16:02
There is a list of numbers, and you need to add units to each cell. Will you add these units one by one? However, if there are too many cells, the manual method will be cumbersome. Now… Read More
2022-07-29 16:15
How time flies. Do you know how long has 2022 passed? There is a built-in function in Excel called the YEARFRAC function. so, let’s explain how to use the Excel YEARFRAC function.
S… Read More
2022-07-25 16:38
If there is something wrong with your network or when you encounter a networking issue. Maybe you can try to reset network settings.
Find the internet icon at the bottom of your computer… Read More
2022-07-21 16:05
We always search for free templates like flyers resumes or business cards online. Actually, we can find almost every kind of templets just in Microsoft Word.
Click on File.
Choose… Read More
2022-07-17 15:56
Sometimes we want to count the times of repeated data in Excel. So, we need to show duplicates in Excel, and quickly find duplicates in Excel, not remove them. Do you know how to quick… Read More
2022-07-13 16:31
Have you ever met such a situation that you need to input a lot of data? You need to check every cell you type. So, you look at your date book and Excel table at the same time to make… Read More
2022-07-09 16:51
We can easily change text direction in Excel to make it look better or save space. For instance, here is a table of fruit sales in 2022.
If we need to print this table at the end of 2… Read More
2022-07-05 16:22
Some malicious websites or malware would ask permission to use your microphone or camera. Therefore, your need to do something to stop this. So, how to turn off microphone on our device to p… Read More
2022-07-01 15:53
Why can the data in the Excel chart made by other people be selected? And the corresponding chart will change along with it. Today we will learn how to make this kind of chart that can switc… Read More
2022-06-27 15:09
We’ve learned how to batch insert underlines and how to underline specific text automatically in Word in our previous tutorials. Today, we are going to learn how to batch underline num… Read More
2022-06-23 15:47
Sometimes we change our word document to read-only mode to protect it from others editing it. If you need someone edit the partial document content but remain intact. That’s Restrict E… Read More
2022-06-19 16:07
There is a location function in Windows 10, it can record the location of our device. If you enable this setting, the Windows system would use your device’s capabilities to determine y… Read More
2022-06-15 15:25
The function of “Where to Get Apps” in windows 10 can help the users to control the type of app they can install on PC. This is mainly to secure our computer from some malware. S… Read More
2022-06-11 15:48
How do we combine data from two columns into one? I’m gonna show you guys two easy ways. Let’s check this out.
There are names from two columns A and B, now we need to com… Read More
2022-06-07 15:55
How do you set a timer to shut down your Windows 10 computer? Or how to turn off your computer at a certain time? There are several ways, but in our today’s tutorial, I’d like to… Read More
2022-06-03 15:19
The folder sharing function of Windows 10 is very convenient and easy to use, but it also increases the security risk of the computer. If you need to disable the default folder sharing, you… Read More
2022-05-30 15:49
I want to ask you guys a question at the beginning of this tutorial. How do you enter a serial number from 1 to 10 in Excel? Type 1, 2, 3… one by one? If you do so, the ten hidden tri… Read More
2022-05-26 15:03
In our daily work, we may need to convert some types of files into another one. How to convert different types of files quickly? There are three ways to solve this problem. Here we go.
No… Read More
2022-05-22 15:52
We always use the shortcut keys Ctrl C and Ctrl V to copy and paste. The windows clipboard saved our copy paste history. You can copy multiple items in it. Many people even don’t know… Read More
2022-05-18 15:45
XML is the abbreviation of Extensible Markup Language. It’s a markup language and file format for storing, transmitting, and reconstructing arbitrary data (From Wikipedia). We can usua… Read More
2022-05-14 15:01
Setting a picture as your Excel background can add some personality to your worksheet. It’s quite easy. Let’s get started.
Go to the Page Layout tab and click on Background… Read More
2022-05-10 15:41
Creating a line chart in Excel is easy. Just select the data area and go to the Insert tab to choose the insert line chart.
There is a worksheet of fruit prices for five months. We can ge… Read More
2022-05-06 15:39
We usually select the cell(s) where we want to add the border firstly, then click the border list arrow from the Home tab to add borders. And click No Border to remove borders.
Today… Read More
2022-05-02 16:18
Time to learn a new function. Today, we are going to learn the UNIQUE function.
The UNIQUE function can help us returns a list of unique values in a list or a range. So, if you need to ex… Read More
2022-04-28 16:11
Today, we are going to learn the usage of the SORT function. The SORT function can help us to sort the rows and columns in a data range. Now, let’s check this out.
Syntax:
=SORT(… Read More
2022-04-24 15:52
Today, we are going to learn the usage of the SEQUENCE Function. Learning to use functions can always make complicated things to be easier.
The Syntax of SEQUENCE Function:
=SEQUENCE (… Read More
2022-04-20 15:25
Sometimes we highlight value or important data in different colors for different purposes. If we need to use color ranking or sort by color in Excel. What should we do?
There is a price t… Read More
2022-04-16 15:33
In our today’s tutorial, we would like to talk about how to delete Chinese text from worksheets in Excel. Actually, you can solve this with VBA code. But most people are not familiar w… Read More
2022-04-12 15:42
Have you ever tried to change the font color on certain text in one cell in Excel? You maybe think of this as very simple. You can test in a worksheet now. It’s would not be such… Read More
2022-04-08 16:20
Do you know how to split cell content in Excel? For example, there are eight product names in one cell.
Product type, number, price, and tax rate also have eight kinds. What can we do… Read More
2022-04-04 15:46
Do you know how to quickly delete or remove blanks in the cell? There are three different scenarios. So we are going to know how to delete useless blanks in different ways.
No.1… Read More
2022-03-31 16:07
There is a table about the growth rates from the year 2015 to 2016.
How to calculate the growth rate?
Growth rate =Starting value– End valuw/starting value.
So we got s… Read More
2022-03-27 16:01
Today, we are going to learn a very easy but useful trick how to split words into separate cells. A case in point is the following picture.
There are roughly 30 name words in cell A1. Now… Read More
2022-03-23 15:51
We usually press Ctrl and A to select all the text, or just use the mouse to highlight a word, a sentence, or a paragraph. Can you believe that there’s an easier way to do this simple… Read More
2022-03-19 15:45
Do you know how to quickly add symbols like pecuniary unit, length unite, and others before or after numbers in Word. let’s take an example.
Here is a table of electrical appliance… Read More
2022-03-15 16:16
Here is a table of seven brand sales from January to June. If we want to clearly see the sales trend of these companies. Inserting sparkline is obsoletely the best way.
Select cell B2… Read More
2022-03-11 15:43
When you are making your presentation slides. It’s terrible that the important chart looks so common. So, how to make an advanced chart to impress your boss or your audience? Let me he… Read More
2022-03-07 15:43
A cool animation effect always makes people’s impression. But it’s quilt difficult for some newbies. Don’t worry, there’s an easy way.
Here is a picture of the cit… Read More
2022-03-03 16:16
Today, we are going to learn four tips to extract unique values in Excel, or you can think of this as removing repeating data. Let’s get started.
The following list contains many re… Read More
2022-02-27 16:02
The FIND function can find a specified text string and return number that represents the starting position of the string.
Syntax
=FIND(find-text, within-text, [start-num])
Find-text… Read More
2022-02-23 15:59
How do you generate a random number between two numbers in Excel? The best answer would exactly be the RANDBETWEEN function. So, how to use the RANDBETWEEN function in Excel? Let’s get… Read More
2022-02-19 16:10
If you want to quickly find out what day of the week it is, are you ready to turn on your phone calendar right away? In Excel, there are actually five ways to quickly figure out what d… Read More
2022-02-15 15:56
My cousin Nancy is learning Chinese recently. So she put together an Excel worksheet and prepared to print it out to study.
Oh, I guess Nancy is not learning Chinese, but fall… Read More
2022-02-11 15:59
Bing Dwen Dwen is the official mascot of the 2022 Winter Olympics, it’s really so cute that so many people want to buy it. Before we get a Bing Dwen Dwen, we can draw one just in Power… Read More
2022-02-07 15:48
If you mind other people seeing some files on your computer, we can choose to hide the files or folders. This is not only very useful, but the steps are also very simple.
Step 1
First… Read More
2022-02-03 15:46
We are now used to sharing our photos and videos on various social platforms. And I think girls like to make pictures look better. Today, we are going to learn how to get grid Photo ju… Read More
2022-01-29 15:40
In the tutorial about VBA variables shared before, maybe you have initially learned the knowledge about data types. Although the data type is not mandatory in VBA, the correct use of the dat… Read More
2022-01-25 15:32
We are very similar to the MAX Function. But do you know the MAXA Function? And what’s the difference between the MAX Function and MAXA Function? Let’s check it out.
At first… Read More
2022-01-22 15:25
We are going to get a new skill again! That’s CLEAN Function. What is the CLEAN Function and how to use it? This tutorial will answer these questions.
The CLEAN function helps you r… Read More
2022-01-18 16:38
In our today’s tutorial, we’ll learn about a new Function. That’s SUMPRODUCT Function. Understanding the syntax is essential if you want to master the use of the function… Read More
Subscribe to Myofficetricks
Get updates delivered right to your inbox!