How to Add the Current Date and Time in Google Sheets

You can utilize the NOW and TODAY functions instead of manually entering times and dates into a Google Sheets spreadsheet. These functions display the current time or date, updating on a regular basis or as your spreadsheet changes.

While the NOW and TODAY features update on a regular basis, you can use keyboard shortcuts to rapidly insert a non-updating time or date stamp.

Adding the Current Time and Date Using NOW

Using the NOW function in Google Sheets to add the current time and date is almost too simple. Although the NOW method does not require any additional arguments, you will need to format any cells that use NOW alone to display the time.

To begin, open or create a new Google Sheets spreadsheet, click on an empty cell, and type =NOW ().

Your Google Sheets spreadsheet should default to utilizing normal formatting for NOW formulas, which shows a timestamp with both the current time and date after it’s been inserted.

Google Sheets will also use the date and time formatting appropriate for your locale by default, which you may alter by going to File > Spreadsheet Settings in your Google Sheets settings. The preceding example utilizes UK date formatting (DD/MM/YY).

The timestamp returned by a formula utilizing the NOW function is usually only updated when your spreadsheet is changed. Additionally, you may arrange your spreadsheet to update every minute or every hour.

To do so, go to File > Spreadsheet Settings, pick the “Calculation” tab, tap on the “Calculation” tab, and then choose the update frequency from the “Recalculation” drop-down menu.

Finding the Date Using the TODAY Function

You can use the TODAY function instead of NOW if you only want to see the current date. Depending on your area, formulas utilizing the TODAY function often display dates in the DD/MM/YY or MM/DD/YY format.

The TODAY function, like NOW, has no arguments. To insert the current date, click on an empty cell and type =TODAY().

Each day, cells with the TODAY formula will update. If you prefer, you can alter the layout to text or numbers.

Formatting Your NOW or TODAY Formula

As we’ve seen, the NOW function normally shows a timestamp that includes both the time and the date by default.

If you wanted to change this, you’d have to use the NOW function to change the formatting of any cells. You may use the TODAY function to modify the format of any formula in the same way.

Select your cell (or cells) and press Format > Number > Date to just show the current date. Instead, select Format > Number > Time to get the current time without the date.

By going to Format > Number > More Formats > More Date and Time Formats, you can further personalize your date or time formatting.

You can change the date and time formatting here to use text, numbers, or special characters such as a forward slash.

This is true for both the NOW and TODAY formulas.

Formulae employing the NOW function can be used to display the current time or date in your Google Sheets spreadsheet in a variety of formats with custom formatting applied.

Inserting Static Times or Dates into Google Sheets

You can’t use NOW or TODAY to add the current time or date to your Google Sheets spreadsheet if you don’t want it to update. Instead, you’ll have to utilize a keyboard shortcut.

Click on the empty cell, then press the Ctrl+; (semi-colon) keys on your keyboard to input the current date.

Instead, press Ctrl+Shift+: (colon) on your keyboard to insert the current time.

 

 

How to Install a New Graphics Card in PC

 

Do you want to install your new computer’s graphics card? You may believe that this is tough or that it needs some technical knowledge. But it’s actually quite simple. You should be able to set up your graphics card on your computer if you follow the instructions below.

To install a graphics card

1. Preparation
2. Install the graphics card
3. Install the driver for your graphics card

Step 1: Preparation

Make sure that the new graphics card you’re intending to utilize is compatible with your computer’s hardware.

You must open your computer casing to check your hardware. Here’s how to go about it:

1.  Turn off your PC, then disconnect all the cables and the attached devices from it.

                Tip: It’s a good idea to label your cables so you can rejoin them afterward.

2. In the side panel, Remove the screws.

                Tip: The panel you need to remove is usually on the left-hand side (if you’re facing the front panel).

3. Remove the side panel.

You’ve successfully opened your PC case. You should also be able to inspect the internal components of your computer.

There are a few other things to consider:

1. Your computer power supply

It’s possible that a more powerful graphics card will use more electricity. So, if you’re adding a new graphics card to your computer, check sure your power enough to supply unit to handle it.

You should perform some Internet study to find out what your graphics card’s system power requirements are. Then open the computer casing and look at the sticker on the power supply unit for information of how much power it supplies.

If your power supply unit can’t handle the graphics card you’re planning to use, you should either upgrade it or choose a graphics card that uses less power.

2. Your motherboard

Check your motherboard to determine if your graphics card is compatible with it.

Check to determine if your motherboard has PCI Express x16 slots, which will allow you to attach your graphics card to it. If you’re intending to use two or more cards, it should have more than one slot.

If you’re upgrading your graphics card, you should take out the old one and replace it with the new one in the same slot.

3. The space inside your computer case

Your new graphics card must be fit in the case of your computer. If you’re using a small case, we recommend upgrading to a larger one, not only because you’ll be able to install your graphics card, but also because your hardware will be kept cooler.

If everything is in working order, the following step is to install the graphics card on your computer.

Step 2: Install the graphics card

Here’s how to install your new graphics card:

1.  Turn off your PC, then disconnect all the cables and the attached devices from it.

                 Tip: It’s a good idea to label your cables so you can rejoin them afterward.

2. In the side panel, Remove the screws.

                Tip: The panel you need to remove is usually on the left-hand side (if you’re facing the front panel).

3. Remove the side panel.

4. If you have an old graphics card, remove it.

5. On your computer case, if you have a graphics card installed, remove the slot cover.

             Note: The slot covers are situated adjacent to the PCI Express x16 slots on your motherboard. You’ll also need to remove two covers if your graphics card is double-wide.

6. Connect the new graphics card to the PCI Express x16 slot on the motherboard (often the closest one to the CPU).

7. Screw your graphics card to the case of your computer.

8. Connect the 6-pin or 8-pin power connector from your power supply unit to your graphics card if it requires independent power.

            Note: Examine your graphics card’s top edge. If a power port is visible, your graphics card will require its own power supply.

9. Reinstall your computer case’s side panel.

10. Connect your graphics card to your monitor with a video cable.
Check your monitor’s video ports to see whether they’re compatible with the ones on your new graphics card. The following are some of the most common video connection standards:

             Note: If the video ports are incompatible, you may need to purchase a video output adapter to convert your video signal and connect to different ports.

11. Connect all of the other wires that were unplugged before.
You can now start your PC. You should be able to see your computer functioning, but it isn’t correctly shown since you don’t have the correct graphics driver loaded.

Step 3: Install the driver for your graphics card

The driver can be installed using the software disc that came with your graphics card. However, the driver it installs may not be the most recent version, and you need to update it to guarantee that your graphics card is functioning properly.

If you are busy, patience, or skills to manually upgrade your graphics driver, Driver Easy can do it for you.

Driver Easy will automatically detect your system and locate the appropriate drivers. You don’t need to know what operating system your computer is running, you don’t have to worry about downloading and installing the wrong driver, and you don’t have to worry about making a mistake during the installation process.

You can use either the Free or Pro version of Driver Easy to download and install your drivers. However, with the Pro version, it simply takes two clicks (with full support and a 30-day money back guarantee):

1. Download and install Driver Easy.

2. Run Driver Easy and select Scan Now from the menu. After that, Driver Easy will check your computer for any problematic drivers.

3. You may manually install the newest and right driver for your graphics card by clicking the Update icon next to it. You can also click the Update All button in the bottom right corner of the screen to automatically update all outdated or missing drivers on your computer (this requires the Pro version; you will be requested to upgrade when you click Update All).

Restart your computer after you’ve updated your graphics card. After that, you should be able to see your system properly displayed.

That concludes our discussion. It’s time to put your new graphics card to work! Also, if you have any questions, please put them in the comments section below.

 

 

 

 

 

 

 

 

 

 

 

 

How to Fix Screen Flickering in Windows 10

The screen on your Windows 10 PC can flicker for a variety of reasons. If you’re not sure what’s causing the problem, try troubleshooting and fixing it with these typical remedies, whether you’re using a laptop or a desktop.

Reseat a Loose Monitor Cable

If monitor cables were not correctly inserted the first time, they may become loose. Your screen may flicker as a result of these unsecured wires. If they weren’t plugged in tightly enough, they may loosen over time.

To rule out this possibility, disconnect your monitor’s cable and re-plug it securely from both the monitor’s back and the PC. Make sure the cable is securely fastened and does not seem or feel loose.

This is true for all sorts of cables, which might become loose for a variety of reasons. To perform this procedure, you don’t need to know what kind of cable you’re using.

Replace Your Monitor Cable

Monitor flickering is frequently caused by low-quality display cables.

If the cable is damaged, or if you only have a cheap one, replace it with a high-quality cable and use it with your display. By high quality, we mean a cable that either originates from the manufacturer of your monitor or from a reputable third-party manufacturer (Most sites, like Amazon, display reviews for each product.).

If you’re not sure which cable type you require (whether HDMI, DisplayPort, or DVI), consult our HDMI vs. DisplayPort vs. DVI guide. Then, go to a site like Amazon and search for the cable you have (for example, an HDMI cable), and you’ll find a plethora of possibilities.

The cable types that your monitor supports are also included in the monitor’s manual. A display usually accepts numerous cable types, so if your current cable is an HDMI cable, your next option might be a DisplayPort cable. They all work in the same way.

That will resolve all of your cable-related difficulties, including screen flickering (That is if the issue was caused by the cable.).

Uninstall Problematic Apps

Apps might also cause the screen on your Windows 10 PC to flicker. Some Norton products, for example, have been known to cause screen flickering on Windows 10 PCs in the past.

You must first identify the problematic app unless you know exactly which app is causing the problem (in which case you should delete that app using the instructions indicated below). Finding out when your screen started to flicker is one technique to do this.

If your problem began after you installed a certain program, that program could be the source of your problem. Check the app’s official website to see if a newer version is available in this scenario. If there is, install it, and your problem will most likely be resolved.

If you can’t find a newer version, you should uninstall the app for the time being. You may have to use a different app until the app developer addresses the problem.

Open “Settings” by pressing Windows+i to begin deleting the malfunctioning software.

In the Settings panel, select “Apps.”

Find the problematic app by scrolling down the right pane. Then choose “Uninstall” from the app’s menu.

To get rid of the app, choose “Uninstall”.

Check if the problem has been resolved by restarting your computer. If the problem persists, try the additional remedies listed below.

Reinstall the Display Drivers

Display drivers, according to Microsoft, are a common source of screen flickering. Reinstalling your display drivers is a simple solution.

Simply uninstall the drivers from your computer, and Windows updates will automatically restore them.

Microsoft suggests starting your computer in Safe Mode to reinstall your drivers. To do so, press Windows+i to enter “Settings” and then “Update & Security” in the Settings app.

Click “Recovery” in the left-hand sidebar of the Settings box. On the right, locate Advanced startup and click “Restart now” beneath it.

A blue screen will show with a few alternatives. On these displays, select Troubleshoot > Advanced options > Startup Settings > Restart.

To reboot your PC by Safe Mode, tap the “4” key on your keyboard. You’re in Safe Mode if you see the words “safe mode” written on your desktop.

Right-click the “Start” menu button in Safe Mode and choose “Device Manager.”

Click the arrow next to “Display adapters” in the Device Manager window. Select “Uninstall device” from the expanded menu by right-clicking the adapter that appears.

Enable the “Delete the driver software for this device” option in the Uninstall Device box. After that, select “Uninstall.”

Reboot your PC.

Go to “Settings” and tap Update & Security > Windows Update >   Check for updates and install any updates that are available.

Your display drivers will be reinstalled by Windows.

Modify the Monitor’s Refresh Rate

The refresh rate of your monitor influences how frequently the content on your screen is refreshed. It’s possible that you’ve set a higher refresh rate and your monitor is having problems keeping up with it.

To alter the refresh rate, press Windows+i to bring up the Settings window, then select “System” from the drop-down menu.

In the left-hand sidebar, select “Display.” Scroll down the right pane and click “Advanced display settings” under Multiple displays.

To change the refresh rate, locate the “Refresh rate” drop-down menu and click it. Try using a lower pace than the one you’re using now to see if it stops your screen from flickering.

If none of these measures, including purchasing a better cable, solves your problem, your monitor may have a hardware problem. If your monitor is still under warranty, you should contact the manufacturer for assistance. It’s possible that your monitor’s hardware has failed.

In situations like this, it’s usually a good idea to seek expert assistance. A specialist may be able to diagnose the issue, and seeking assistance may be less expensive than purchasing a new display—depending on how expensive your display is.

 

 

 

 

How to Open Links in Google Sheets with a Single Click

To open a link in a Google Sheets spreadsheet, you must make two clicks by default. You can make the link open with a single click by using a workaround. We’ll demonstrate how to do it.

How This Works

This solution publishes your Google Sheets spreadsheet as a web page. You then open the links on this web page with a single click.

For your published web page, Google assigns you a unique URL. This URL is used to access your spreadsheet via the internet as a web page. Make sure you only share this URL with people you want to have access to the data in your spreadsheet.

Open Links in a Google Sheets Spreadsheet with a Single Click

First, open your spreadsheet in Google Sheets in your web browser.

When the spreadsheet opens, go to the Google Sheets menu bar and select File > Publish to the Web.

Select the “Link” tab on the “Publish to the web” pop-up that appears. Then, choose “Entire Document” and select whether you want to publish your entire spreadsheet or just a single sheet. From the second drop-down menu, choose “Web Page.”

Next, to see more options, select “Published content & settings.”

Activate the “Automatically republish when changes are made” option in the expanded pop-up, then choose “Start publishing.”

Choose “OK” in the prompt that appears on your screen.

Now, in the “Publish to the web” pop-up, you can see a link. To copy the link, click this link box and tap Ctrl+c on Windows or Command+c on Mac.

In your browser, open a new tab, paste the copied link in the address bar, then hit “Enter.”

You may now open any link in your spreadsheet (which has been published as a web page) by just clicking on it.

That’s how you make it easier to open links in your spreadsheets!

For privacy reasons, it’s usually better to unpublish the web page once you’ve finished working with your links. To do so, open your spreadsheet in Google Sheets, go to File > Publish to the Web in the menu bar, and then choose “Stop publishing.”

That’s all.

 

[Solved] Computer Turns On but No Display | 2021 Tips

When you turn on your computer, the screen remains black? This is extremely aggravating, and you are not alone. This problem is being reported by a large number of Windows users. The good news is that it is fixable. Here are five options to consider.

Try these fixes:

It’s possible that you won’t have to try all of them. Simply work your way down the list until you discover one that suits your needs.

1. Check if your monitor is turned on
2. Reconnect your monitor to your computer
3. Disconnect your peripherals
4. Reinstall your RAM
5. Reset your BIOS settings to default
6. Bonus tip: Update your device drivers

Fix 1: Check if your monitor is turned on

If your computer boots up but displays nothing, check to see if your monitor is functioning properly.

Check your monitor’s power light to make sure it’s switched on.

If your monitor won’t switch on, disconnect the power adapter and reconnect it to the wall outlet. If the issue persists, you will need to take your monitor to a repair facility.

If your display is working properly, try the following solution.

Fix 2: Reconnect your monitor to your computer

Your problem could possibly be caused by a bad connection between your display and your computer. Reconnecting the two devices is most likely the solution to your problem in this scenario. Here’s how you can do it:

1) Hold the power button down until your computer shuts down.

2) Disconnect the video cable that connects your computer to your monitor.

3) Examine your port connectors on your PC and on your monitor.

Note: If any of your device’s connectors are bent or damaged, you’ll need to take it to a repair shop.

4) Examine your video cable for any damage. Reconnect your computer to your monitor if the video cable is in good condition. Alternatively, if you have another video cable, try connecting the two devices with it.

5) Turn on your computer and observe if it boots up normally.

If your computer breaks again, keep reading to see how to fix it.

Fix 3: Disconnect your peripherals

A black screen might also be caused by some devices attached to your computer. Disconnect all of your peripherals to determine if that’s the source of the issue. Here’s how you can do it:

1) Hold the power button down until your computer shuts down.

2) Disconnect all peripherals (your printer, scanner, mouse, etc.).

3) Turn on your computer once more.

If your computer boots up normally, one of the peripherals you removed is the source of the problem. Each device should be reinstalled into your PC and tested each time. Then you’ll track down the precise gadget that’s causing your issue. (Replace the device once you’ve identified it, or get help from the device’s maker.)

If your machine still won’t boot, try the solution below.

Fix 4: Reinstall your RAM

This issue can potentially be caused by a bad connection between your RAM and motherboard. You’ll need to reinstall your RAM in this instance. Here’s how to do it:

1) Hold the power button down until your computer shuts down.

2) Disconnect the power supply’s AC power cord, then open your computer casing.

Note: Depending on the type of machine, this method will vary. Consult your computer’s documentation or seek professional assistance if you don’t know how to accomplish it.

3) Remove your RAM from the memory slot on your motherboard.

RAM looks like this:

4) Put your RAM into the slot.

5) Turn on your computer after connecting the AC power cord to the power supply.

Don’t panic if your computer still won’t boot up properly. Take a look at the solution below.

Fix 5: Reset your BIOS settings to default

Your PC may also boot with a black screen due to incorrect BIOS settings. You should reset your BIOS to factory settings to check if that’s the issue. Here’s how you can do it:

1) Turn off your computer by pressing and holding the power button.

2) Disconnect the power supply’s AC power cord, then open your computer casing.

3) Remove the CMOS battery from your motherboard with your fingernail or a non-conductive screwdriver.

This is what the CMOS battery looks like:

4) Reinstall your CMOS battery after waiting 5 minutes.

5) Turn on your computer and connect the AC power cord to the power source to see whether the problem persists.

Hopefully, this material was beneficial! Please let me know which option worked for you, or if you have any other suggestions for how to resolve this problem. I’d love to hear what you have to say!

 

Bonus tip: Update your device drivers

A missing or outdated device driver can cause a variety of issues on your computer, therefore updating your device drivers should always be your first choice to avoid further difficulties. There are two safe ways to get the driver:

Manual driver update – You can manually update your drivers by going to the website of your hardware manufacturer and looking for the most recent right driver. Only install drivers that are compatible with your Windows version.

Automatic driver update – If you don’t have the time, patience, or computer skills to manually update your drivers, Driver Easy can do it for you. Driver Easy will detect your system and locate the appropriate driver for your graphics product and Windows version, which it will then download and install correctly:

1) Download and install Driver Easy.

2) Launch Driver Easy and select Scan Now. After that, Driver Easy will check your computer for any problematic drivers.

3) Next to the graphics driver, click the Update option to automatically download the latest version of that driver, which you can then manually install (you can do this with the FREE version).

Alternatively, you can select Update All to have all the missing or out-of-date drivers on your system immediately downloaded and installed. (The Pro version is required for this, which includes full support and a 30-day money back guarantee. When you click Update All, you’ll be asked to upgrade.)

 

 

 

 

 

 

 

How to Extract Images from PDF Files

You can extract the images embedded in PDF files and store them in a folder if you want to utilize them elsewhere. We’ll teach you how to accomplish it on Windows 10 and Mac using two distinct techniques.

Extract Images from a PDF with Adobe Acrobat Reader DC

The Adobe Acrobat Reader DC app provides a simple and free way to extract photos from a PDF. Not only can you open PDFs with this program, but you can also extract their multimedia content. You can save selected photos from a PDF to a folder on your computer in this manner.

Download and install the free Acrobat Reader DC program for Windows 10 or Mac if you haven’t already. Then use this app to open your PDF.

Click the selection tool (an arrow icon) in the toolbar towards the top of the window when Acrobat Reader opens. This tool will be used to select images from your PDF.

Next, navigate to the page in your PDF that contains the image you wish to extract. To select an image, click it.

Then, From the menu, right-click the image and choose “Copy Image”.

 

The image you’ve chosen has now been copied to your clipboard. This image can now be pasted into any image editor on your pc.

If you’re using Windows, use the Paint app and paste the image using Ctrl+V. Then, in Paint’s menu bar, go to File > Save to save the image.

Open the Preview software on your Mac and go to File > New from Clipboard in the menu bar. Then, to save the image, go to File > Save.

Your saved image file functions in the same way that any other image on your computer. It’s possible to add it in documents, upload it to websites, and more.

Use Adobe Photoshop to Extract Images from a PDF

A custom feature in Photoshop allows you to import the contents of a PDF file. You can use this to load your PDF and extract all of the photos.

To utilize this strategy, open Photoshop on a Mac or Windows 10. Click File > Open in the menu bar in Photoshop, then browse to the PDF file from which you wish to extract photos.

The “Import PDF” window in Photoshop will appear. To view all of your PDF images, pick the “Images” radio button at the top of this window.

All of the images in your PDF files will be displayed in Photoshop. Select the image you want to extract. Press and hold Shift and then click the photos to choose multiple images.

After you’ve made your selections, click “OK” at the bottom of the window.

Each image will be opened in a new tab in Photoshop. Select File > Close All in Photoshop’s menu bar to save all of these photos to a folder on your computer.

Photoshop will ask whether you want to save changes to your images. Enable the “Apply to All” option in this popup, then click “Save.”

The typical “Save As” window in Photoshop is next. At the top, click the “Save As” box and give your image a name. Then select a format for your image from the “Format” drop-down option. Finally, at the bottom of the window, click “Save.” Each image must go through this process.

If you’re unsure about the picture format, go with “PNG,” as it will work in most circumstances.

Now, the images that you selected are free from their PDF prison!

 

 

How to Share Audio Recordings from Google Recorder

On Pixel smartphones, Google Recorder is one of the greatest apps from the search giant. It can transcribe audio recordings into text, making them searchable, and it can also access and share those recordings from the cloud. We’ll show you how to do it.

If you’re not familiar with Google Recorder, it’s a Pixel phones-only app. Behind a modest design, the software hides several sophisticated features. Your recordings, as well as the transcriptions, can be stored at recorder.google.com if it’s enabled.

Open the Recorder app on your Google Pixel device to get started. To use the cloud capabilities, you’ll need a Pixel 3 or newer phone.

If you’re using the app for the first time, you’ll see a splash screen with information on what it can do. Select “Get Started”.

If you choose to back up your recordings to the cloud, the app will prompt you. To continue, tap “Back Up Recordings.”

Simply hit the red button at the bottom of the screen to make an audio recording.

When you’re finished, use the pause button to stop recording.

You have the option of adding your location to the recording, which will be utilized when searching through it. Select the “Add Location” option to do so.

Then, you can add a title to the recording file and click “Save” to complete.

You can share a recording in two ways: through the app or through the website. Let’s begin with the app. Press and hold  a recording from the list.

The recording will be highlighted from now on (as indicated by the check mark). Click the share icon in the top bar after selecting any other recordings to share.

You’ll have four options in the share menu (just the first two if you select several recordings):

• Audio: Share the .m4a audio file.
• Transcript: Share the transcript as a .txt file or through Google Docs.
• Link: Get a link to the recording in the cloud.
• Video Clip: Create a video clip with waveform animation or transcript text.

After you’ve chosen one of the sharing methods, you’ll be able to select an app to share it with.

In a web browser like Google Chrome or Microsoft Edge, go to recorder.google.com for the second method. Make sure you’re using your Google account to log in.

In the left sidebar, you’ll find a list of your recordings. Choose the one you want to share.

Next to your profile icon in the top-right corner, choose the three-dot menu icon.

From the menu, tap “Share”.

On the internet, the sole choice is to share the link. Choose between “Private to Me” or “Shared Link,” then “Copy Link.”

You may now post the link anywhere you like, and anyone will be able to listen to the audio and read the transcript in real-time, depending on your privacy settings. They won’t need the Recorder app to listen to it if they use the link.