Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 06-24-2020, 09:09 PM
kingston123 kingston123 is offline Excel thinking my name as month, how to stop that? Windows 10 Excel thinking my name as month, how to stop that? Office 2013
Advanced Beginner
Excel thinking my name as month, how to stop that?
 
Join Date: Sep 2018
Posts: 85
kingston123 is on a distinguished road
Default Excel thinking my name as month, how to stop that?

I tried to duplicate my name using fill handle, But Excel giving July, August, september.....instead of July, July, July......




Please help me.
Reply With Quote
  #2  
Old 06-26-2020, 09:30 PM
Purfleet Purfleet is offline Excel thinking my name as month, how to stop that? Windows 10 Excel thinking my name as month, how to stop that? Office 2019
Expert
 
Join Date: Jun 2020
Location: Essex
Posts: 345
Purfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to behold
Default

It works in a logical order. Most times you will want the next month in a list, so August.

However if you want it repeated just give it a different patten like July and July - highlight both and drag down with the fill handle

Numbers work the opposite way (i.e will repeat unless you give it 1 & 2 then they will run in order
Reply With Quote
  #3  
Old 06-27-2020, 09:31 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Excel thinking my name as month, how to stop that? Windows 7 64bit Excel thinking my name as month, how to stop that? Office 2010
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,766
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

Or drag down holding the shift key?
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel day date month year Function greginky Excel 1 01-05-2016 02:19 AM
Excel thinking my name as month, how to stop that? Thinking of upgrading from Word 2007 - A question WaltR Word 10 12-17-2015 04:58 PM
start-stop month dates in calendar madison320 Project 0 06-24-2011 08:15 AM
Excel thinking my name as month, how to stop that? Formulate month in Excel 2010 meninio Excel 4 01-25-2011 12:13 PM
Wishful thinking Steve_D Word 1 08-12-2010 07:14 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:57 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft