Software-OK
≡... News | ... Home | ... FAQ | Impressum | Contact | Listed at | Thank you |

  
HOME ► Faq ► FAQ - Microsoft-Office ► ««« »»»

Paste the same text into multiple Excel cells at the same time!


In Microsoft Excel , you can enter the same data or text into multiple cells at once using the following simple steps!

The classic marking of several cells in MS Excel, as well as inserting with the key Ctrl + V is probably familiar to everyone! 

Direct entry of the same text in several lines!

1. Select all cells for which you want the same text.

2. Enter the desired text directly.
(Optionally start the entry with the F2 key)

3. After entering the text, press the Ctrl + Enter key instead of the Enter key

(... see Image-1 Point 1)

After completing the above steps, the text will be automatically entered in all selected cells. This tip is useful when you have data with the same prefix and need to add something to the end of each cell. 

For example, the above steps were followed to type "SoftwareOK.de" in all of the highlighted cells, as shown in the image. Once you're done I could press F2 on a selected cell, go to the end and add "001" to make the cell "SoftwareOK.com 001". You could do this for each cell in order to have SoftwareOK.com 001-016.

(Image-3) Paste the same text into multiple Excel cells at the same time!
Paste the same text into multiple Excel cells at the same time!

-
▲ Back to the top ▲




FAQ 48: Updated on: 11 May 2021 14:08 Windows
Microsoft-Office

More space for messages in Outlook, classic view in the list!


If you want to have more space for messages in the email list in Outlook as in Outlook Express earlier, you dont have to despair In the table / list view,
Microsoft-Office

Delete all emails at once or selective in Outlook!


You want to clean up spam or trash quickly and not delete every email in Outlook individually   Content: 1. Delete at once in Outlook?  2. Delete
Microsoft-Office

Missing attachments in Microsoft Outlook!


If the file attachment is too large, for example over 20 MB, the file can be excluded due to the guidelines of your e-mail server Its not always 20MB as
Microsoft-Office

Open Word, Excel and PowerPoint files without Microsoft Office!


If you dont have Word, Excel and PowerPoint files from one of the Microsoft Office packages, you can still open it When you work with files created in
Microsoft-Office

Difference between Word * .doc and * .docx documents?


For a long time Microsoft Word only used one proprietary format for saved files: * .doc and then it became * .docx  The pressure of the competition, as
Microsoft-Office

Quickly insert bullets and numbered lists in Word!


Quickly inserting bullets and numbered lists in Microsoft Word is a handy feature Quite simply, you can go to the "Home" tab and then click the "Show/Hide"
Microsoft-Office

How do I create a caption/header in an Excel spreadsheet?


There are several ways to add a custom title to a spreadsheet in Microsoft Excel, which is very good Titles arent just for filenames. You can place a title

»»

  My question is not there in the FAQ
Asked questions on this answer:
Keywords: microsoft, office, paste, same, text, into, multiple, excel, cells, time, enter, data, once, using, following, simple, steps, classic, marking, several, Questions, Answers, Software




    

  + Freeware
  + Order on the PC
  + File management
  + Automation
  + Office Tools
  + PC testing tools
  + Decoration and fun
  + Desktop-Clocks

  + SoftwareOK Pages
  + Micro Staff
  + Freeware-1
  + Freeware-2
  + Freeware-3
  + FAQ
  + Downloads

  + Top
  + Desktop-OK
  + The Quad Explorer
  + Don't Sleep
  + Win-Scan-2-PDF
  + Quick-Text-Past
  + Print Folder Tree
  + Find Same Images
  + Experience-Index-OK
  + Font-View-OK


  + Freeware
  + ShortDoorNote
  + AutoHideDesktopIcons
  + BlankAndSecure
  + AlwaysMouseWheel
  + NewFileTime
  + DesktopClock3D
  + PointerStick
  + DesktopImages3D
  + WinPing
  + PAD-s


Home | Thanks | Contact | Link me | FAQ | Windows 2021 | Windows 10 | English-AV | Impressum | Translate | PayPal | PAD-s

 © 2023 by Nenad Hrg softwareok.de • softwareok.com • softwareok.com • softwareok.eu
0.077


► Easily find and remove duplicate images is convenient! ◄

► Save Desktop Layout in *.dok file or *.ini! ◄

► Use DiskPart Utility in Windows 10/11! ◄

This website uses cookies to ensure you get the best experience on our website more Infos & Privacy Policy
....