Excel 2013 :: Disable Automatically Scrolling To The Top Of Current Cell?

Jan 2, 2014

I am using Excel 2013. I have a spreadsheet that has a lot of very tall cells. When I use the scrollbar to scroll to certain parts of the spreadsheet it will automatically scroll up or down to the top of a cell. So if I want to view the middle of two tall cells that take up the whole screen it will automatically scroll up to the top of the highest cell that I'm currently viewing.

I just want to be able to scroll to where I want to scroll without Excel moving me up or down. I've tried to find answers on message boards but no luck.

View 2 Replies


Excel 2013 :: Disable Ctrl+Mouse Wheel?

Apr 8, 2014

Is there any method to disable Ctrl + mouse wheel function in excel 2013, actually I want to disable zoom in and out functionality but don't want to disable normal scrolling.

View 2 Replies View Related

Excel 2013 :: VBA Macro For Selecting Current Week Range

May 30, 2013

I currently have this beast of a code running in Excel 2013:

HTML Code:
Dim NextCol As Long

'Copy data
Workbooks.Open Filename:= _

[Code] ........

However the issue lies in that once the data is refreshed, the slicers reading off the above raw data/pivots, automatically select all weeks, however this is not beneficial for the data being presented.

Is there anyway to have, once the Pivots have been updated, for the macro to then check and select current week range (beginning Monday) only?

View 4 Replies View Related

VBA Code To Disable Scrolling Up Or Down

Dec 30, 2011

What is the vba code to disable scrolling Up or down?

View 1 Replies View Related

Excel 2013 :: Automatically Reapply Filter

May 22, 2014

I have a Table ("Table2") in a worksheet ("Dashboard") that contains monthly data arranged in rows. I have made the data fields show #NA for months I want to exclude based on dynamic criteria.

Now, I would like to automatically filter out the rows (months) with #NA so that they are not charted.

It works manually but I have to Right Click on the Table --> Filter --> Reapply every time the source data changes. How can I make this happen automatically so that the user does not have to manually reapply each time.

View 6 Replies View Related

Excel 2013 :: Automatically Calculate Area Between Two Charts?

Dec 22, 2013

I have Excel 2013.

Find attached a sample fileDummy for area between.


View 3 Replies View Related

Excel 2013 :: All Sheets Being Automatically Changed To Currency Format

Dec 2, 2013

We have 3 PCs, all running MS Office 2013. On 1 of these machines, it is doing strange things with formatting. If you open a document or try to paste anything into certain documents, it decides everything is currency format and assigns all sorts of wrong formatting to the entire sheet, or the entire document. There may be some cells in the doc that are indeed currency, but only a small proprtion. If I open a new, fresh document and paste into that document, it does not do this, it seems to work normally, only applying currency formatting where it might be applicable. On some larger docs that have this issue, no matter what I do, it just continues to apply these strange settings.

View 2 Replies View Related

Excel 2013 :: How To Make Automatically Fill In Dates For Weekdays Only And Skip Thursday

Feb 9, 2014

I have class monday, tuesday, wednesday & friday but no class thursday. How can I make automatically fill in dates for weekdays only and skip thursday using excel 2013's "Fill" function then "series" ??

View 6 Replies View Related

Excel 2013 :: Pivot Table Compare Current Data With Refresh Data And Format New Values?

Jun 18, 2014

vba in excel 2013 pivot table that updates from an online CRM rows are a to h and it can be any number of rows. What I am trying to do is track progress. In column f values indicate probability for success 10 25 45 90, which can go up or down. The pivot table is refreshed to get the latest values from CRM. the update is handled by a connection to the crm not in the vba.

So far I been researching methods to conditionally format values that went up, down or remained the same since the last refresh with up down and across arrows. I have managed to piece together what I think should work but alas it is not. So I have come to you internet.

My code first clears any formatting and goes down the column avoiding null or empty cells, comparing the values in column f to values in column j.
I have 3 conditions greater than, less than or equal to, and would like add an icon for each based on the result of the comparison.

Finally when it finishes the column the code copies the current values in the pivot table column f to column j outside the pivot table which i hope to be able to hide once the cf works. The code is below

[Code] .....

View 1 Replies View Related

Automatically Scrolling A Worksheet?

Jul 28, 2013

I have a worksheet with a column("A:A") of about 1000names. The user will start at the top and work down, entering stuff into other columns for some ofthe names. My need is: How do you automatically scroll, with code, say row 48to the top of the worksheet when the user reaches row 48 with?.

View 2 Replies View Related

Automatically Add Username, Current Date And Time Each Tiime Any Cell Is Changed

Feb 27, 2009

I am looking to have a macro which will automatically add the username and date to a cell, when the cell above changes (or in this case =x). I have a bit of code from a previous project, but I have changed Target.Row to Target.Column and it is not behaving as I require:

Private Sub Worksheet_Change(ByVal Target As Range)
If Not Intersect(Range("B2:BZ2"), Target) Is Nothing Then
Range("C" & Target.Column).Value = Format(Date, "dd-mmm") & " " & Format(Time, "hh:mm") & " by " & (Application.UserName)
End If
End Sub

See the attachment for the example. What I need is whenever row 3 ="x" I need the corresponding cell in row "d" to update with the latest date, time and username. Please not the macro is currently not active on the sheet as i've added the ' character.

View 3 Replies View Related

Excel 2013 :: Change Text In Cell Based On Date In Another Cell

Apr 14, 2014

I have the the following spreadsheet: [URL] My formula in Columns A to E is the following:

=IF(ISNA(VLOOKUP(Query1_2[@Branch],Master!A:J,10,FALSE)),"Branch Not Open",VLOOKUP(Query1_2[@Branch],Master!A:J,10,FALSE))

I would like to do the following in Column A: If the date in Column C is greater than today, then Column A must also say "Branch Not Open". I have tried the following:

=IF(ISNA(VLOOKUP(Query1_2[@Branch],Master!A:J,10,FALSE)),"Branch Not Open",VLOOKUP(Query1_2[@Branch],Master!A:J,10,FALSE)),IF(C:C<=TODAY,"Branch Not Open, IF(AND(C:C=>TODAY,VLOOKUP(Query1_2[@Branch],Master!A:I,9,FALSE)))

But Excel does not like the formula at all.

View 1 Replies View Related

Excel 2013 :: Cell Change Animation

Mar 27, 2013

In Excel 2013, there is a transition in the cell when values change. I have a DDE feed updating data every few seconds and the folding animation is distracting. Is there a way to turn this off?

View 5 Replies View Related

Excel 2013 :: Remove First 5 Characters From A Cell?

Mar 5, 2014

I have attached a spread sheet with some code I recoded with macro recorder. I have been searching for some extra code to insert in the middle of the recorded code which will remove the first 5 characters from the active cell and past the result to the next page. I have seen a lot of relevant code but haven't been able to get any to work in my code.

[Code] .....

I am using Windows7 with Excel 2013.

Attached File : DeleteFirst5Char.xlsm‎

View 10 Replies View Related

Excel 2013 :: CF Entire Row If Cell Contains Formula

Feb 14, 2014

I need CF entire row if column D cells contains formula. All formulas starts with =, so I guess It should be worked around it, but I don't know exactly how. I Use excel 2013.

View 1 Replies View Related

Excel 2013 :: Formulas Loosing Cell Reference?

Jul 24, 2013

The spreadsheet works in Excel 2000 when you open it in any newer version it is corrupted. Which is fine so we are rewriting it in Excel 2010/2013.

We have data in columns A:E which comes from the refreshable query. Data in F:I are different formulas based on the data from the query. The number of rows we get will vary from query to query. The headers never change just the data. How can we make it so that when no matter the data length the formulas will always autofill up or down depending on the data length?

View 9 Replies View Related

Excel 2013 :: Date Placed In Cell When Text Entered In A2

May 8, 2013

Is there a formula which places the date In A5 whenever text is entered in A2 - Excel 2013

View 9 Replies View Related

Excel 2013 :: Change Same Cell In Multiple XLS Files

May 2, 2014

what I need to do to update a folder full of files. There are 120+ .xls files in one folder, the merged cell A30-V38 needs to change its current text to "4th Quarterly Printer Preventative Maintenance".

I have zero prior knowledge of visual basic, and have Excel 2013.

View 2 Replies View Related

Excel 2007 :: Clicking On Cell Auto-selects Cell Next To It - Cannot Disable

Nov 16, 2010

Whenever she clicks on a cell, the cell to the right of it is also selected. When she tries using tab to move to a new cell, she can only move between the two selected cells. Same with using the enter key. As such, it is extremely difficult for her to modify only one cell, since she always has two selected.

The F8 key, as well as Ctrl+F8. However, pressing the F8 key only adds more cells to the autoselection, and Ctrl+F8 allows her to select one cell, but also highlights the cells around it, and when we tried to select other cells, every cell we clicked stayed highlighted.

Additionally, sometimes when she clicks a cell, it will just select that one cell. Click it again, and the problem is back. I haven't been able to determine any patterns to this behavior, and I know there is no problem with the input (the keyboard and mouse are standard-issue in our lab, and we keep them well maintained).

View 8 Replies View Related

Excel 2013 :: Concatenate Header Row Text When Row Cell Is Not Empty

Jun 5, 2014

I am trying to concatenate entries into one cell so that when uploaded, the comma-separated contents will be treated as tags. copperberry sample file.xlsxSee attached sample file. Wherever there is a 1 in a row, I want to take the column header text above that 1 and concatenate it with subsequent text in the cell at the end of the row. See sample end result in cell J2. I assume I need an IF statement, but I'm not sure how to phrase it to collect all the concatenations needed. There are 200+ rows.

Windows 8.1
Excel 2013

View 2 Replies View Related

Excel 2007 To 2013 Not Allowing Data To Be Added To Cell?

Sep 10, 2013

I have created an Excel spreadsheet in 2007. When a friend opens the workbook in Excel 2013, It does not let him add data to the cells. ( just one column which is the "date" column) The worksheet is not locked or protected.

When I right-click on the column and goto format cells, protection, the box is ticked, but the note says this doesn't take effect unless the sheet is protected witch it isnt.

View 6 Replies View Related

Excel 2013 :: Playing WAV File Based On Cell Value Change

Aug 6, 2014

I have a spreadsheet with a database query attached (refreshing every 60 seconds) showing a stock summary by product.

I need the spreadsheet to play a .WAV file when values change. i.e.;

If cell A1 <6, play sound1.wav
If cell A2 <6, play sound1.wav
If cell A3 <6, play sound2.wav
If cell A4 <6, play sound2.wav

This may need to be repeated several times based on certain criteria. I have a total of about 30 cells which I need to be looked at individually (not a sum of) and to play the relevant sound.

I have seen different people try to tackle this in different ways. The ideal way would be creating alarms in VBA and triggering them using a formula, but I cannot get these to work in Excel 2010 or 2013.

View 6 Replies View Related

Excel 2013 :: Extract Cell Value If It Has Conditional Formatting Color?

Mar 26, 2014

I have been trying to make a macro to automatically calculate the quantity I need to increase or decrease our purchase orders.


As the On Hand quantity decreases I have set conditional formatting to determine how much we should order according to a percentage of the Stocking Level and turns the desired cell yellow. For each row the macro would need to identify which cell in columns L through O is yellow from conditional formatting, use that value and subtract the On Order quantity, then put the result in the Adjust PO Qty (+/-) column so I know how much to decrease the order if negative or increase if positive.

View 1 Replies View Related

EXCEL 2013 :: Show Currency Exchange Rate In One Cell

Apr 16, 2014

Is it possible in Excel 2013 to have one cell show current exchange rate of Euro to dollar?

View 1 Replies View Related

Excel 2013 :: Create New Values Based On Number In One Cell?

Jul 21, 2014

I have the following data set with about 500 rows. It has one large value in column A, followed by a number between 1 and 24 in column B.

I am trying in Excel 2013 to develop a formula that will: divide A by the value in cell BPlace in cell C, D, E, F... the result of this division, where the number of times the value is repeated depends on the value in B. E.g.

Example of source values/data set:




(about 500 rows more)

An example of the output result that I am looking for:


In above example, the value in column B is 2, so the result of the division of value A with value B is repeated twice. In case value B would be 18, the value would be repeated 18 times...

I have been trying to do this in Excel for more than 2 hours, but I did not manage to complete it.

View 2 Replies View Related

Excel 2013 :: How To Create A List In One Cell From Array While Removing Duplicates

Jul 23, 2014

------ A ------------------- B
Bill323@gmail.com ---------Red
Sue223@gmail.com -------Green
Sue223@gmail.com -------Yellow
Bill323@gmail.com ---------Red
Bill323@gmail.com --------Yellow
John123@gmail.com ------Yellow
Sue223@gmail.com --------Blue

- C --------------- D ---
John ------------Blue, Yellow
Bill --------------Red, Yellow
Sue------------Green, Yellow, Blue

I am using Excel 2013 on Windows 7. In the above example columns A & B is the given list to process, and Columns C & D contain the result I am trying to achieve. The major part of this that I am having trouble on combining, separating them with commas in another cell, and ignoring a duplicate value. You can see bill has two red values, but I only need it displayed once in column D.

View 4 Replies View Related

Excel 2013 :: Inserting Link In Cell Changes The Default Font Type And Size?

Feb 23, 2014

I used Excel 2013 and Win 8.1

When I insert a Hyperlink in a cell, this changes the Default Font Type and Size

View 1 Replies View Related

Excel 2013 :: Macro - Paste To Column Cell Location Based On Variable?

Jun 16, 2014

I have data in E6-E67 on Sheet 1. Based on the date in A2 on that sheet, I need to paste to a column in Sheet 2. In excel, I am able to get the cell location through vlookup and get the correct column number/cell reference. When it gets to the paste location, I am stumped on how to format that line of code? Do I need sometime of variable? I tried to use the address/lookup code but it does not work.

I have excel 2013.

View 4 Replies View Related

Excel 2010 :: Rolling (scrolling) Columns

Oct 24, 2013

I have a spreadsheet with standard rows and columns - nothing elaborate. There is a section with a column for each month of the year, with 10 line items showing monthly totals for various business functions. What I would like to do, if possible, is ... instead of showing all 12 columns (making for a very long spreadsheet), I would like to show only 4 of the 12 month columns (in a window) and scroll through the months with a scroll bar.

View 3 Replies View Related

Excel 2010 :: Prevent Scrolling To Bottom Row

Jun 28, 2011

I'm currently creating a workbook whereby I have (regrettably) highlighted entire columns and formatted these columns to show borders. The reason I did this was because drawing them in manually (I thought) would take much longer with the way the worksheet is laid out.

Obviously highlighting the entire column has meant that borders were drawn all the way down to the bottom row of the workbook, and so the vertical scroll bar cannot effectively be 'dragged' up and down as even a tiny movement will cause it to scroll right past the worksheet.

I have tried running a macro to clear contents and formatting for all the unused rows, but the scroll bar remains to be a pain.

I want the scroll bar to only scroll down to a few cells below the available work space like it should do.

View 9 Replies View Related

Copyrights 2005-15 www.BigResource.com, All rights reserved