bar

Hi, I am trying to figure out how to get rid of this bar in Excel, I upgraded to Win10 and it was not there in Win7! Thanks! (image link on ImgBB below:) https://ibb.co/0B8d7ws

Hi guys. I have a large datasheet in which i have tabel 1. This tabel contains 5 coloums and 200 rows. I Would like to insert/create a search bar in which i Can type words and then the search bar should ‘hide’ Rows that does not have any of the five coloum resultat in common with the searched...

Hello Everyone, I am attempting to rounddown the time to the nearest previous interval. I have some data in excel. It logs the start time of a bar. Eg the 16:00 bar begins at 16:00 and completes at 16:00:59 Now when the time is at 17:20 I would like excel to look for the time 16:00 (starting...

Hello. Im new around here. I wasn't able to answer the question I was looking for by googling, so wondered if I'll find it her. Maybe someone will answer. I'm looking for a way to make in formula bar sum numbers to be colored, like here. I want numbers to have different colors. In example every...

I am a big fan of the Quick Access Tool bar which I have customized to give easy access to my most commonly used functions. I have them grouped logically. For some reason the icons don't stay put. The icon in one location keeps moving elsewhere on the Tool Bar. Occasionally, another icon...

Need to make a (daily) hourly bar graph for my work schedule. The data part would be the name, starting time, ending time. I work like to select a horizontal bar graph view as in the image to produce this graph...

So I have a "Tool Bar" across the top of my worksheet that I want to remain the exact same size and position except when row 1 is hidden the tool bar should be hidden as well. If I hide columns etc I don't want the tool bar to change size but I can only seem to get it to either not size or hide...

I want to make a bar graph for a schedule for a work week. Column A: (format: Date) I'll put in the date Column B: (format: Name) I'll insert the Name Column C: (format: Time In) I'll insert the Time started Column D: (format: Time Out) I'll insert the Time started Column E: (formula needed for...

Hi All I've been using Excel on Mac for many years and never had this issue till now. It's probably more that I don't understand than an issue. I have always been able to double click on sheets in Excel Objects, they would open in a window with a gray title bar and the option to close, min or...

Hi all, Let's say I have a counter of two different brands, JG and OM. I have a horizontal scroll bar on a userform which I want to show the split between the brand allocation. If I have 300 allocations, and 200 are JG and 100 are OM, I would like the bar to look as follows...

I'm running a simulation with over 500,000 iterations. I've got screenupdating turned on on, statusBar display is on, and I've activated the status bar to print on the iteration number, but it prints out 6000+ and then stops. Could it be that the software is running faster than the screen can...

HI Guys i have he below data <tbody> Jan Feb Mar 2017 10 11 5 2017 target 5 9 13 2018 14 13 12 2018 Target 10 15 11 2019 7 3 29 2019 target 10 2 8 </tbody> I am trying to create a graph with months on the X axis and then 3 bars showing , which represents each year and inside...

Hi all, I have just installed office 2016 x64 and I am experimenting for the first time with the new SDI interface with which I am not familiar. Say, you have two workbooks opened, each on its seperate window (same excel process) Now, say you want to hide the formula bar just for one...

I'm stuck. I have several hundred rows of data with various columns (see example): <tbody> Date Segment Product Sales Rep Region Sales Jan-18 Enterprise Widget 1 Bob MW $500 Feb-19 SMB Widget 3 Cindy NW $250 Jun-18 SMB Widget 3 Suzzie SE $1000 Jan-19 Commercial Widget 2 Bob SW $35...

Can someone please help with constructing a code that will enable me to restrict any form of pasting (ctrl V or right click) in a specific cell. NOTE: This cell is an access signIn area and as a result, the status bar disappears when you click on it (to avoid situations where onlookers can see...

Sorry, not sure how to word exactly what I'm looking for, and Google has not returned what I need. I have a data set with results from 3 divisions (A,B,C). I'd like to create a bar chart the stacks quarterly results from A and B and displays them next to C. i.e. in Quarter 1 A had $40 million...

I've inherited a workbook with a bullseye symbol in cell A1. The curious thing is that the formula bar shows nothing in the cell other than a wide space. When I check it with the formula in B1 =CODE(A1), it returns 158. When I enter the formula =CHAR(B1) it returns the character "ž". If I...

Hello, Is it possible to hide toolbar, formula bar, ribbon etc.. for only one workbook? link for the workbook : http://s000.tinyupload.com/index.php?file_id=66089730027655191139

Hi I have set up automated timeline (Gant Style) workbook for colleagues whichworks fine but they have now asked me if I can have the bar colour changeautomatically if a task is past due e.g. Green while it is in scope and redwhen it is Out of Scope. This is not something I have been asked for...

My first post here. I know this is an old program--but it does everything I need a spreadsheet to do :) Somehow my Menu bar is all screwed up. With my W7 Pro config, there is a Deep Blue bar at the very top, the menu bar is about 1/3 the width of the screen and is less height than the Formatting...